DBA Data[Home] [Help]

APPS.OE_OPT_PROCESS dependencies on BOM_EXPLOSIONS

Line 43: FROM BOM_EXPLOSIONS BOMEXP

39: SELECT 'Y'
40: ,DECODE( BOMEXP.COMPONENT_CODE,
41: x_options_comp_code, NULL, OELIN.LINE_ID )
42: ,BOMEXP.COMPONENT_CODE
43: FROM BOM_EXPLOSIONS BOMEXP
44: ,MTL_SYSTEM_ITEMS MTLITM
45: ,SO_LINES OELIN
46: WHERE BOMEXP.TOP_BILL_SEQUENCE_ID = x_lines_comp_seq_id
47: AND BOMEXP.EXPLOSION_TYPE = 'OPTIONAL'

Line 367: FROM BOM_EXPLOSIONS

363: , HIGH_QUANTITY
364: INTO P_Component_Quantity
365: , P_Low_quantity
366: , P_High_Quantity
367: FROM BOM_EXPLOSIONS
368: WHERE TOP_BILL_SEQUENCE_ID = P_Component_Sequence_Id
369: AND COMPONENT_CODE = P_Component_Code
370: AND EXPLOSION_TYPE = 'OPTIONAL'
371: AND PLAN_LEVEL > 0