APPS.DDR_REF_UTIL_PKG dependencies on DDR_R_MFG_ITEM

Line 57: FROM DDR_R_MFG_ITEM_CMPNY

53: l_return VARCHAR2(30);
54:
55: CURSOR cur_cmpny IS
56: SELECT 1
57: FROM DDR_R_MFG_ITEM_CMPNY
58: WHERE MFG_CMPNY_CD = p_hchy_cd;
59:
60: CURSOR cur_div IS
61: SELECT 1

Line 62: FROM DDR_R_MFG_ITEM_DIV

58: WHERE MFG_CMPNY_CD = p_hchy_cd;
59:
60: CURSOR cur_div IS
61: SELECT 1
62: FROM DDR_R_MFG_ITEM_DIV
63: WHERE MFG_DIV_CD = p_hchy_cd
64: AND EFF_TO_DT IS NULL;
65:
66: CURSOR cur_grp IS

Line 68: FROM DDR_R_MFG_ITEM_GRP

64: AND EFF_TO_DT IS NULL;
65:
66: CURSOR cur_grp IS
67: SELECT 1
68: FROM DDR_R_MFG_ITEM_GRP
69: WHERE MFG_GRP_CD = p_hchy_cd
70: AND EFF_TO_DT IS NULL;
71:
72: CURSOR cur_class IS

Line 74: FROM DDR_R_MFG_ITEM_CLASS

70: AND EFF_TO_DT IS NULL;
71:
72: CURSOR cur_class IS
73: SELECT 1
74: FROM DDR_R_MFG_ITEM_CLASS
75: WHERE MFG_CLASS_CD = p_hchy_cd
76: AND EFF_TO_DT IS NULL;
77:
78: CURSOR cur_sbc IS

Line 80: FROM DDR_R_MFG_ITEM_SBC

76: AND EFF_TO_DT IS NULL;
77:
78: CURSOR cur_sbc IS
79: SELECT 1
80: FROM DDR_R_MFG_ITEM_SBC
81: WHERE MFG_SBC_CD = p_hchy_cd
82: AND EFF_TO_DT IS NULL;
83:
84: CURSOR cur_item IS

Line 86: FROM DDR_R_MFG_ITEM

82: AND EFF_TO_DT IS NULL;
83:
84: CURSOR cur_item IS
85: SELECT 1
86: FROM DDR_R_MFG_ITEM
87: WHERE MFG_ITEM_NBR = p_hchy_cd
88: AND EFF_TO_DT IS NULL;
89:
90: CURSOR cur_sku IS