DBA Data[Home] [Help]

APPS.EGO_IMPORT_BATCHES_PKG dependencies on BOM_GLOBALS

Line 453: SELECT bom_globals.retrieve_message('BOM', 'BOM_PRIMARY') DISPLAY_NAME,

449: START WITH bst.structure_type_id = v_structure_type_id
450: CONNECT BY PRIOR bst.parent_structure_type_id =
451: bst.structure_type_id)
452: UNION
453: SELECT bom_globals.retrieve_message('BOM', 'BOM_PRIMARY') DISPLAY_NAME,
454: BOM_Globals.GET_PRIMARY_UI() ALTERNATE_DESIGNATOR_CODE,
455: structure_type_iD
456: FROM BOM_STRUCTURE_TYPES_B b
457: WHERE structure_type_name = 'All-Structure Types') QRSLT

Line 454: BOM_Globals.GET_PRIMARY_UI() ALTERNATE_DESIGNATOR_CODE,

450: CONNECT BY PRIOR bst.parent_structure_type_id =
451: bst.structure_type_id)
452: UNION
453: SELECT bom_globals.retrieve_message('BOM', 'BOM_PRIMARY') DISPLAY_NAME,
454: BOM_Globals.GET_PRIMARY_UI() ALTERNATE_DESIGNATOR_CODE,
455: structure_type_iD
456: FROM BOM_STRUCTURE_TYPES_B b
457: WHERE structure_type_name = 'All-Structure Types') QRSLT
458: WHERE ((ALTERNATE_DESIGNATOR_CODE = BOM_Globals.GET_PRIMARY_UI() OR

Line 458: WHERE ((ALTERNATE_DESIGNATOR_CODE = BOM_Globals.GET_PRIMARY_UI() OR

454: BOM_Globals.GET_PRIMARY_UI() ALTERNATE_DESIGNATOR_CODE,
455: structure_type_iD
456: FROM BOM_STRUCTURE_TYPES_B b
457: WHERE structure_type_name = 'All-Structure Types') QRSLT
458: WHERE ((ALTERNATE_DESIGNATOR_CODE = BOM_Globals.GET_PRIMARY_UI() OR
459: ALTERNATE_DESIGNATOR_CODE IN
460: (SELECT DISTINCT ALTERNATE_DESIGNATOR_CODE
461: FROM BOM_ALTERNATE_DESIGNATORS_VL b, mtl_parameters p
462: WHERE p.master_organization_id = v_master_org_id