APPS.BOM_CSTRSCCR_XMLP_PKG dependencies on BOM_ALTERNATE_DESIGNATORS

Line 47: BOM_ALTERNATE_DESIGNATORS BAD

43: AND not exists (
44: SELECT
45: 'Alternate designator exists'
46: FROM
47: BOM_ALTERNATE_DESIGNATORS BAD
48: WHERE BAD.ORGANIZATION_ID = CSLLC.ORGANIZATION_ID
49: AND BAD.ALTERNATE_DESIGNATOR_CODE = I_SNAPSHOT_DESIGNATOR );
50: CURSOR LOOP_ROWS(I_ROLLUP_ID IN NUMBER) IS
51: SELECT

Line 83: BOM_ALTERNATE_DESIGNATORS_VL

79: SELECT
80: DISPLAY_NAME
81: INTO P_ALT_BOM_DESG_DSP
82: FROM
83: BOM_ALTERNATE_DESIGNATORS_VL
84: WHERE ORGANIZATION_ID = NVL(LP_ORGANIZATION_ID
85: ,lp_default_org_id)
86: AND ALTERNATE_DESIGNATOR_CODE = LP_ALT_BOM_DESG;
87: END IF;

Line 93: BOM_ALTERNATE_DESIGNATORS_VL

89: SELECT
90: DISPLAY_NAME
91: INTO P_ALT_RTG_DESG_DSP
92: FROM
93: BOM_ALTERNATE_DESIGNATORS_VL
94: WHERE ORGANIZATION_ID = NVL(LP_ORGANIZATION_ID
95: ,lp_default_org_id)
96: AND ALTERNATE_DESIGNATOR_CODE = P_ALT_RTG_DESG;
97: END IF;