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 75: BOM_ALTERNATE_DESIGNATORS_VL

71: SELECT
72: DISPLAY_NAME
73: INTO P_ALT_BOM_DESG_DSP
74: FROM
75: BOM_ALTERNATE_DESIGNATORS_VL
76: WHERE ORGANIZATION_ID = NVL(P_ORGANIZATION_ID
77: ,P_DEFAULT_ORG_ID)
78: AND ALTERNATE_DESIGNATOR_CODE = P_ALT_BOM_DESG;
79: END IF;

Line 85: BOM_ALTERNATE_DESIGNATORS_VL

81: SELECT
82: DISPLAY_NAME
83: INTO P_ALT_RTG_DESG_DSP
84: FROM
85: BOM_ALTERNATE_DESIGNATORS_VL
86: WHERE ORGANIZATION_ID = NVL(P_ORGANIZATION_ID
87: ,P_DEFAULT_ORG_ID)
88: AND ALTERNATE_DESIGNATOR_CODE = P_ALT_RTG_DESG;
89: END IF;