DBA Data[Home] [Help]

APPS.GMD_LM_MIGRATION dependencies on IC_ITEM_MST_B

Line 103: FROM ic_item_mst_b

99: * *************************************************************** */
100: PROCEDURE populate_lm_sprd_dtl_sec_qty IS
101: CURSOR C_check_Item_dual_ind(vItem_id NUMBER) IS
102: SELECT item_um2
103: FROM ic_item_mst_b
104: Where item_id = vItem_id
105: AND dualum_ind > 0;
106:
107: CURSOR C_get_lm_sprd_dtl IS

Line 111: l_dual_um ic_item_mst_b.item_um2%TYPE;

107: CURSOR C_get_lm_sprd_dtl IS
108: SELECT *
109: FROM lm_sprd_dtl;
110:
111: l_dual_um ic_item_mst_b.item_um2%TYPE;
112:
113: BEGIN
114: FOR lm_sprd_dtl_rec IN C_get_lm_sprd_dtl LOOP
115: OPEN C_check_Item_dual_ind(lm_sprd_dtl_rec.Item_id);