ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 202DC352D271DAE4E0633E07F60A582DY SELECT &P_ITEM_SEG ITEM_NUMBER, &P_CAT_SEG CATEGORY , CUR_MSIVL.description DESCRIPTION, CUR_MSIVL.primary_uom_code UOM_CODE, OWN_MSI.primary_uom_code OWNING_ORG_PUOM_CODE, DECODE( :P_SORT_OPTION, 5, RSH.freight_carrier_code, 6, RPAD(TO_MP.organization_code,5,' ')||'TO_OOD.organization_name', 7, RSH.shipment_num) SORT_COLUMN, CIQT.organization_id OWNING_ORG_ID, FROM_MP.organization_id FROM_ORG_ID, FROM_MP.organization_code FROM_ORG_CODE, TO_MP.organization_code TO_ORG_CODE, FOB_LU.meaning FOB_POINT, RSH.shipment_num SHIPMENT_NUM, RSH.shipped_date SHIP_DATE, RSH.expected_receipt_date+NVL(TO_MSI.postprocessing_lead_time,0) ARRIVAL_DATE, RSH.freight_carrier_code FREIGHT_CARRIER_CODE, RSH.waybill_airbill_num WAYBILL_AIRBILL_NUM, RSH.num_of_containers NUM_OF_CONTAINERS, CCG.cost_group COST_GROUP, DECODE( :P_ITEM_REVISION, 1, RPAD(NVL(CIQT.revision,' '),3,' '), NULL ) REVISION, ROUND(SUM(CIQT.rollback_qty),:P_QTY_PRECISION) QUANTITY, DECODE( CIQT.organization_id, CIQT.from_organization_id, FROM_MSI.primary_uom_code, TO_MSI.primary_uom_code ) UOMCODE, CIQT.inventory_item_id ITEM_ID, ROUND((NVL(CICT.item_cost,0)*:P_EXCHANGE_RATE1),:P_EXT_PREC) UNIT_COST, DECODE(:P_COST_TYPE_ID,CICT.cost_type_id,' ','*') DEFAULTED, ROUND((SUM(CIQT.rollback_qty * NVL(CICT.item_cost,0) )*:P_EXCHANGE_RATE1)/:ROUND_UNIT) * :ROUND_UNIT TOTAL_COST, -- bug 17209556 has made changes, round off by currency precision ROUND_UNIT --ROUND((SUM(CIQT.rollback_qty * NVL(CICT.item_cost,0) )*:P_EXCHANGE_RATE1),:P_EXT_PREC) TOTAL_COST, CASE WHEN from_mp.process_enabled_flag <> to_mp.process_enabled_flag THEN 0 ELSE decode( mip.MATL_INTERORG_TRANSFER_CODE, 1, ROUND((NVL(RSL.transfer_cost,0)/ (gl_currency_api.get_rate(COD.set_of_books_id,:P_CURRENCY_CODE,sysdate,:P_CURR_TYPE))), :P_EXT_PREC), 2, ROUND((NVL(RSL.transfer_cost,0)/ (gl_currency_api.get_rate(COD.set_of_books_id,:P_CURRENCY_CODE,sysdate,:P_CURR_TYPE))), :P_EXT_PREC), 3, ROUND((decode(mip.fob_point, 2,( NVL(CICT.item_cost,0 )*:P_EXCHANGE_RATE1 * rsl.TRANSFER_PERCENTAGE/100), 1,(nvl(mta.rate_or_amount,0)*:P_EXCHANGE_RATE1) )/(gl_currency_api.get_rate(COD.set_of_books_id,:P_CURRENCY_CODE,sysdate,:P_CURR_TYPE))), :P_EXT_PREC), 4, ROUND((decode(mip.fob_point, 2,( NVL(CICT.item_cost,0 )*:P_EXCHANGE_RATE1 * rsl.TRANSFER_PERCENTAGE/100), 1,(nvl(mta.rate_or_amount,0)*:P_EXCHANGE_RATE1) )/(gl_currency_api.get_rate(COD.set_of_books_id,:P_CURRENCY_CODE,sysdate,:P_CURR_TYPE))), :P_EXT_PREC) ) END XFER_COST, ROUND((NVL(RSL.transportation_cost,0)/ (gl_currency_api.get_rate(COD.set_of_books_id,:P_CURRENCY_CODE,sysdate,:P_CURR_TYPE))), :P_EXT_PREC) XPORT_COST, BOM_CSTRITVR_XMLP_PKG.itemcatformula( &P_CAT_SEG, :CATEGORY_SEGMENT, :CATEGORY_PSEG) ITEMCAT, fnd_flex_xml_publisher_apis.process_kff_combination_1('category_segment', 'INV', 'MCAT', CUR_MCK.STRUCTURE_ID, NULL, CUR_MCK.CATEGORY_ID, 'ALL', 'Y', 'VALUE') CATEGORY_SEGMENT, fnd_flex_xml_publisher_apis.process_kff_combination_1('category_pseg', 'INV', 'MCAT', CUR_MCK.STRUCTURE_ID, NULL, CUR_MCK.CATEGORY_ID, 'ALL', 'Y', 'PADDED_VALUE') CATEGORY_PSEG, nvl(fnd_flex_xml_publisher_apis.process_kff_combination_1('item_pseg', 'INV', 'MSTK', 101, CUR_MSIVL.ORGANIZATION_ID, CUR_MSIVL.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE'),&P_ITEM_SEG) ITEM_PSEG, nvl(fnd_flex_xml_publisher_apis.process_kff_combination_1('item_segment', 'INV', 'MSTK', 101, CUR_MSIVL.ORGANIZATION_ID, CUR_MSIVL.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE'),&P_ITEM_SEG) ITEM_SEGMENT, BOM_CSTRITVR_XMLP_PKG.item_qtyformula(CUR_MSIVL.primary_uom_code, DECODE( CIQT.organization_id, CIQT.from_organization_id, FROM_MSI.primary_uom_code, TO_MSI.primary_uom_code ) ,CIQT.inventory_item_id ,ROUND(SUM(CIQT.rollback_qty),:P_QTY_PRECISION) ) ITEM_QTY, BOM_CSTRITVR_XMLP_PKG.xport_cost_totalformula( ROUND((NVL(RSL.transportation_cost,0)/ (gl_currency_api.get_rate(COD.set_of_books_id,:P_CURRENCY_CODE,sysdate,:P_CURR_TYPE))), :P_EXT_PREC), ROUND(SUM(CIQT.rollback_qty),:P_QTY_PRECISION)) XPORT_COST_TOTAL, BOM_CSTRITVR_XMLP_PKG.xfer_cost_totalformula(CASE WHEN from_mp.process_enabled_flag <> to_mp.process_enabled_flag THEN 0 ELSE decode( mip.MATL_INTERORG_TRANSFER_CODE, 1, ROUND((NVL(RSL.transfer_cost,0)/ (gl_currency_api.get_rate(COD.set_of_books_id,:P_CURRENCY_CODE,sysdate,:P_CURR_TYPE))), :P_EXT_PREC), 2, ROUND((NVL(RSL.transfer_cost,0)/ (gl_currency_api.get_rate(COD.set_of_books_id,:P_CURRENCY_CODE,sysdate,:P_CURR_TYPE))), :P_EXT_PREC), 3, ROUND((decode(mip.fob_point, 2,( NVL(CICT.item_cost,0 )*:P_EXCHANGE_RATE1 * rsl.TRANSFER_PERCENTAGE/100), 1,(nvl(mta.rate_or_amount,0)*:P_EXCHANGE_RATE1) )/(gl_currency_api.get_rate(COD.set_of_books_id,:P_CURRENCY_CODE,sysdate,:P_CURR_TYPE))), :P_EXT_PREC), 4, ROUND((decode(mip.fob_point, 2,( NVL(CICT.item_cost,0 )*:P_EXCHANGE_RATE1 * rsl.TRANSFER_PERCENTAGE/100), 1,(nvl(mta.rate_or_amount,0)*:P_EXCHANGE_RATE1) )/(gl_currency_api.get_rate(COD.set_of_books_id,:P_CURRENCY_CODE,sysdate,:P_CURR_TYPE))), :P_EXT_PREC) ) END, ROUND(SUM(CIQT.rollback_qty),:P_QTY_PRECISION)) XFER_COST_TOTAL, BOM_CSTRITVR_XMLP_PKG.tot_costformula( CIQT.organization_id, FROM_MP.organization_id, OWN_MSI.primary_uom_code, DECODE( CIQT.organization_id, CIQT.from_organization_id, FROM_MSI.primary_uom_code, TO_MSI.primary_uom_code ) , CIQT.inventory_item_id, ROUND(SUM(CIQT.rollback_qty),:P_QTY_PRECISION), ROUND((NVL(CICT.item_cost,0)* :P_EXCHANGE_RATE1),:P_EXT_PREC), ROUND((SUM(CIQT.rollback_qty * NVL(CICT.item_cost,0) )*:P_EXCHANGE_RATE1)/:ROUND_UNIT) * :ROUND_UNIT ) TOT_COST FROM cst_inv_qty_temp CIQT, cst_inv_cost_temp CICT, rcv_shipment_headers RSH, rcv_shipment_lines RSL, cst_cost_groups CCG, mfg_lookups FOB_LU, mtl_parameters OWN_MP, mtl_parameters FROM_MP, mtl_parameters TO_MP, mtl_system_items_vl CUR_MSIVL, mtl_system_items OWN_MSI, mtl_system_items FROM_MSI, mtl_system_items TO_MSI, mtl_categories_kfv CUR_MCK, cst_organization_definitions COD, mtl_interorg_parameters mip, mtl_transaction_accounts mta WHERE CICT.organization_id (+) = CIQT.organization_id AND CICT.inventory_item_id (+) = CIQT.inventory_item_id AND CICT.cost_type_id (+) = CIQT.cost_type_id AND ( OWN_MP.primary_cost_method = 1 OR NVL(CICT.cost_group_id,CIQT.cost_group_id) = CIQT.cost_group_id) AND RSH.shipment_header_id = RSL.shipment_header_id AND RSL.shipment_line_id = CIQT.shipment_line_id AND RSH.shipped_date <= to_date(:P_AS_OF_DATE1,'DD-MON-YYYY HH24:MI:SS') AND mta.transaction_id (+) = RSL.mmt_transaction_id AND mta.accounting_line_type (+)= 11 AND CCG.cost_group_id = CIQT.cost_group_id AND FOB_LU.lookup_type = 'MTL_FOB_POINT' AND FOB_LU.lookup_code = DECODE(CIQT.organization_id,CIQT.to_organization_id,1,2) AND OWN_MP.organization_id = CIQT.organization_id AND FROM_MP.organization_id = CIQT.from_organization_id AND TO_MP.organization_id = CIQT.to_organization_id AND CUR_MSIVL.organization_id = :P_ORG_ID AND CUR_MSIVL.inventory_item_id = CIQT.inventory_item_id AND OWN_MSI.organization_id = CIQT.organization_id AND OWN_MSI.inventory_item_id = CIQT.inventory_item_id AND FROM_MSI.organization_id = CIQT.from_organization_id AND FROM_MSI.inventory_item_id = CIQT.inventory_item_id AND TO_MSI.organization_id = CIQT.to_organization_id AND TO_MSI.inventory_item_id = CIQT.inventory_item_id AND CUR_MCK.category_id = CIQT.category_id AND mip.from_organization_id = ciqt.from_organization_id AND mip.to_organization_id = ciqt.to_organization_id AND COD.organization_id = FROM_MP.organization_id GROUP BY &P_ITEM_SEG, &P_CAT_SEG, CUR_MSIVL.description, CUR_MSIVL.primary_uom_code, OWN_MSI.primary_uom_code, DECODE( :P_SORT_OPTION, 5, RSH.freight_carrier_code, 6, RPAD(TO_MP.organization_code,5,' ')||'TO_OOD.organization_name', 7, RSH.shipment_num), CIQT.organization_id, FROM_MP.organization_id, FROM_MP.organization_code, TO_MP.organization_code, FOB_LU.meaning, RSH.shipment_num, RSH.shipped_date, RSH.expected_receipt_date+NVL(TO_MSI.postprocessing_lead_time,0), RSH.freight_carrier_code, RSH.waybill_airbill_num, RSH.num_of_containers, CCG.cost_group, DECODE( :P_ITEM_REVISION, 1, RPAD(NVL(CIQT.revision,' '),3,' '), NULL ), DECODE( CIQT.organization_id, CIQT.from_organization_id, FROM_MSI.primary_uom_code, TO_MSI.primary_uom_code ), ROUND((NVL(CICT.item_cost,0)*:P_EXCHANGE_RATE1), :P_EXT_PREC), CIQT.inventory_item_id, DECODE(:P_COST_TYPE_ID,CICT.cost_type_id,' ','*'), CASE WHEN from_mp.process_enabled_flag <> to_mp.process_enabled_flag THEN 0 ELSE decode( mip.MATL_INTERORG_TRANSFER_CODE, 1, ROUND((NVL(RSL.transfer_cost,0)/ (gl_currency_api.get_rate(COD.set_of_books_id,:P_CURRENCY_CODE,sysdate,:P_CURR_TYPE))), :P_EXT_PREC), 2, ROUND((NVL(RSL.transfer_cost,0)/ (gl_currency_api.get_rate(COD.set_of_books_id,:P_CURRENCY_CODE,sysdate,:P_CURR_TYPE))), :P_EXT_PREC), 3, ROUND((decode(mip.fob_point, 2,( NVL(CICT.item_cost,0 )*:P_EXCHANGE_RATE1 * rsl.TRANSFER_PERCENTAGE/100), 1,(nvl(mta.rate_or_amount,0)*:P_EXCHANGE_RATE1) )/(gl_currency_api.get_rate(COD.set_of_books_id,:P_CURRENCY_CODE,sysdate,:P_CURR_TYPE))), :P_EXT_PREC), 4, ROUND((decode(mip.fob_point, 2,( NVL(CICT.item_cost,0 )*:P_EXCHANGE_RATE1 * rsl.TRANSFER_PERCENTAGE/100), 1,(nvl(mta.rate_or_amount,0)*:P_EXCHANGE_RATE1) )/(gl_currency_api.get_rate(COD.set_of_books_id,:P_CURRENCY_CODE,sysdate,:P_CURR_TYPE))), :P_EXT_PREC) ) END, ROUND((NVL(RSL.transportation_cost,0)/ (gl_currency_api.get_rate(COD.set_of_books_id,:P_CURRENCY_CODE,sysdate,:P_CURR_TYPE))), :P_EXT_PREC) --added , fnd_flex_xml_publisher_apis.process_kff_combination_1('category_segment', 'INV', 'MCAT', CUR_MCK.STRUCTURE_ID, NULL, CUR_MCK.CATEGORY_ID, 'ALL', 'Y', 'VALUE') , fnd_flex_xml_publisher_apis.process_kff_combination_1('category_pseg', 'INV', 'MCAT', CUR_MCK.STRUCTURE_ID, NULL, CUR_MCK.CATEGORY_ID, 'ALL', 'Y', 'PADDED_VALUE') , fnd_flex_xml_publisher_apis.process_kff_combination_1('item_pseg', 'INV', 'MSTK', 101, CUR_MSIVL.ORGANIZATION_ID, CUR_MSIVL.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') , fnd_flex_xml_publisher_apis.process_kff_combination_1('item_segment', 'INV', 'MSTK', 101, CUR_MSIVL.ORGANIZATION_ID, CUR_MSIVL.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') having ROUND(SUM(CIQT.rollback_qty),:P_QTY_PRECISION) <> 0 order by SORT_COLUMN,ITEMCAT,ITEM_PSEG,OWNING_ORG_PUOM_CODE,FROM_ORG_ID,FROM_ORG_CODE, TO_ORG_CODE BOM CSTRITVR_XML F CST Etat des stocks en transit valorisés (1) Imported from BI Publisher Description: Etat des stocks en transit valorisés Application: Bills of Material Source: Etat des stocks en transit valorisés (XML) Short Name: CSTRITVR_XML DB package: BOM_CSTRITVR_XMLP_PKG US SDS - CST Intransit Value Imported from BI Publisher Description: Intransit Value Report Application: Bills of Material Source: Intransit Value Report (XML) Short Name: CSTRITVR_XML DB package: BOM_CSTRITVR_XMLP_PKG BI Publisher 1=1 :ext_precision :p_as_of_date :p_as_of_date1 :p_cat_from :p_cat_num :p_cat_seg :p_cat_set_name :p_cat_to :p_category_set :p_conc_request_id :p_cost_type :p_cost_type_dummy :p_cost_type_dummy1 :p_cost_type_id :p_curr_type :p_currency_code :p_currency_dsp :p_def_cost_type :p_detail_level :p_exchange_rate :p_exchange_rate1 :p_exchange_rate_char :p_exp_item :p_ext_prec :p_item_from :p_item_revision :p_item_seg :p_item_to :p_org_id :p_org_where :p_organization :p_own :p_qty_precision :p_receipt :p_rpt_option :p_shipment :p_sort_by :p_sort_option :p_title :p_trace :p_view_cost :p_zero_cost :qty_precision :round_unit 1 -100 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y F ID organisation ID organisation US Organization Id Organization Id 2 -90 :p_gl_num Number fnd_profile.value('MFG_CHART_OF_ACCOUNTS_ID') Y F ID plan de comptes ID plan de comptes US Chart of Accounts Id Chart of Accounts Id 3 -80 :p_cost_type_dummy Number SELECT 1 FROM MTL_PARAMETERS WHERE ORGANIZATION_ID = fnd_profile.value('MFG_ORGANIZATION_ID') AND PRIMARY_COST_METHOD = 1 F CST_SRS_COST_TYPE_DUMMY Type coût fictif US CST_SRS_COST_TYPE_DUMMY Cost Type dummy 4 -70 :p_cat_num Number SELECT STRUCTURE_ID FROM MTL_CATEGORY_SETS WHERE CATEGORY_SET_ID = :$flex$.category_set Y F Structure de catégorie Structure de catégorie US Category Structure Category Structure 5 -60 :p_inverse_rate Char fnd_profile.value('DISPLAY_INVERSE_RATE') Y F CST_SRS_INVERSE_RATE Afficher taux inverse US CST_SRS_INVERSE_RATE Display Inverse Rate 6 -50 :p_rate_type Number 2 Y F CST_SRS_RATE_TYPE Type de taux de change US CST_SRS_RATE_TYPE Exchange Rate Type 7 -40 :p_qty_precision Number fnd_profile.value('REPORT_QUANTITY_PRECISION') F Précision des quantités Précision des quantités US Quantity Precision Quantity Precision 8 -30 :p_view_cost Number fnd_profile.value('CST_VIEW_COSTS') F Voir privilège coût Voir privilège coût US View Cost Privilege View Cost Privilege 9 -20 :p_trace Char fnd_profile.value('MRP_TRACE') F Mode Trace Mode Trace US Trace Mode Trace Mode 10 -10 :debugflag Char N F Indicateur Diagnostic Indicateur Diagnostic US DebugFlag DebugFlag 11 10 :p_title Char F Titre Titre US Title Title 12 20 :p_rpt_option LOV Oracle CST_SRS_RPT_DETAIL_OPTION Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_RPT_DETAIL_OPTION' order by meaning SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'CST_RPT_DETAIL_OPTION' AND LOOKUP_CODE = 1 Y F Option d'édition Option d'édition US Report Option Report Option 13 30 :p_sort_option LOV Oracle CST_SRS_INTRANSIT_RPT_SORT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_ITEM_REPORT_SORT' and lookup_code in (1,2,5,6,7) order by lookup_code SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'CST_ITEM_REPORT_SORT' AND LOOKUP_CODE = 1 Y F Option de tri Option de tri US Sort Option Sort Option 14 40 :p_cost_type_id LOV Oracle CST_SRS_AVG_COST_TYPE Y select cct.cost_type_id id, cct.cost_type value, cct.description description from cst_cost_types cct,mtl_parameters mp where nvl(cct.organization_id,fnd_profile.value('MFG_ORGANIZATION_ID'))=fnd_profile.value('MFG_ORGANIZATION_ID') and nvl(cct.disable_date,sysdate+1)>sysdate and mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and ((cct.cost_type_id=2 and mp.primary_cost_method=2) or (cct.cost_type_id!=2)) and ((cct.cost_type_id=1 and mp.primary_cost_method=1) or (cct.cost_type_id!=1)) and :$flex$.cst_srs_cost_type_dummy=1 order by cost_type SELECT COST_TYPE FROM CST_COST_TYPES WHERE COST_TYPE_ID = (SELECT PRIMARY_COST_METHOD FROM MTL_PARAMETERS WHERE ORGANIZATION_ID = fnd_profile.value('MFG_ORGANIZATION_ID')) AND :$FLEX$.CST_SRS_COST_TYPE_DUMMY = 1 Y F Type de coût Type de coût US Cost Type Cost Type 15 50 :p_as_of_date DateTime select fnd_date.date_to_displaydt(sysdate) from dual Y F En date du En date du US As of Date As of Date 16 60 :p_item_from Char F Article - De Article - De US Item From Item from 17 70 :p_item_to Char F Article - A Article - A US Item To Item to 18 80 :p_category_set LOV Oracle CST_SRS_CATEGORY_SET Y select category_set_id id, category_set_name value, description description from mtl_category_sets where mult_item_cat_assign_flag='N' order by value,description SELECT CATEGORY_SET_NAME FROM MTL_CATEGORY_SETS A, MTL_DEFAULT_CATEGORY_SETS B WHERE B.FUNCTIONAL_AREA_ID = 5 AND A.CATEGORY_SET_ID = B.CATEGORY_SET_ID Y F Jeu de catégories Jeu de catégories US Category Set Category set 19 90 :p_cat_from Char F Catégorie - De Catégorie - De US Category From Category From 20 100 :p_cat_to Char F Catégorie - A Catégorie - A US Category To Category To 21 110 :p_currency_code LOV Oracle CST_SRS_CURRENCY_CODE Y select currency_code id, currency_code value, description description from fnd_currencies_vl where trunc(nvl(start_date_active,sysdate-1))<sysdate and trunc(nvl(end_date_active,sysdate+1))>sysdate order by value,description SELECT CURRENCY_CODE FROM GL_SETS_OF_BOOKS SOB, ORG_ORGANIZATION_DEFINITIONS OOD WHERE OOD.ORGANIZATION_ID = fnd_profile.value('MFG_ORGANIZATION_ID') AND SOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID Y F Devise Devise US Currency Currency 22 120 :p_exchange_rate_char LOV Oracle CST_SRS_EXCHANGE_RATE_C Y select actual_rate id, display_rate value, period description from cst_gl_translation_view where org_id=fnd_profile.value('MFG_ORGANIZATION_ID') and code=:$flex$.cst_srs_currency_code and inverse=:$flex$.cst_srs_inverse_rate and rate_type=:$flex$.cst_srs_rate_type order by period_year desc,period_num desc Y F Taux de change Taux de change US Exchange Rate Exchange Rate 23 130 :p_receipt LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE='SYS_YES_NO' AND LOOKUP_CODE=1 Y F Inclure les réceptions en attente Inclure les réceptions en attente US Include Pending Receipts Include Pending Receipts 24 140 :p_shipment LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE='SYS_YES_NO' AND LOOKUP_CODE=1 Y F Inclure les livraisons Inclure les livraisons US Include Shipments Include Shipments 25 150 :p_own LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE='SYS_YES_NO' AND LOOKUP_CODE=1 Y F Afficher seulement vos stocks Afficher seulement vos stocks US Only Display Inventory You Own Only display inventory you own 26 160 :p_item_revision LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE='SYS_YES_NO' AND LOOKUP_CODE=2 Y F Quantités par version Quantités par version US Quantities By Revision Quantities by Revision 27 170 :p_zero_cost LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE='SYS_YES_NO' AND LOOKUP_CODE=2 Y F Afficher les coûts zéro seulement Afficher coût zéro seulement US Display Zero Costs Only Display zero cost only 28 180 :p_exp_item LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE='SYS_YES_NO' AND LOOKUP_CODE=2 Y F Inclure les articles passés en charges Inclure les articles passés en charges US Include Expense Items Include expense items