DBA Data[Home] [Help]

APPS.EGO_IMPORT_BATCHES_PKG dependencies on BOM_ALTERNATE_DESIGNATORS_VL

Line 443: FROM BOM_ALTERNATE_DESIGNATORS_VL bad,

439: SELECT DISPLAY_NAME
440: FROM (SELECT DISTINCT bad.display_name DISPLAY_NAME,
441: bad.alternate_designator_code ALTERNATE_DESIGNATOR_CODE,
442: bad.structure_type_id STRUCTURE_TYPE_ID
443: FROM BOM_ALTERNATE_DESIGNATORS_VL bad,
444: BOM_STRUCTURE_TYPES_VL bsvl
445: WHERE bad.alternate_designator_code IS NOT NULL
446: AND bad.structure_type_id IN
447: (SELECT bst.structure_type_id

Line 461: FROM BOM_ALTERNATE_DESIGNATORS_VL b, mtl_parameters p

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
463: AND b.ORGANIZATION_ID = p.organization_id)) AND
464: ((v_structure_type_id =
465: (Select Structure_Type_id