APPS.GMF_GMFINVAL_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS

Line 100: L_FROM_UOM MTL_SYSTEM_ITEMS_B.PRIMARY_UNIT_OF_MEASURE%TYPE;

96: AND EFF_START_DATE <= V_TRANS_DATE
97: AND EFF_END_DATE >= V_TRANS_DATE
98: AND DELETE_MARK = 0;
99: X_COST_ORGANIZATION_ID MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
100: L_FROM_UOM MTL_SYSTEM_ITEMS_B.PRIMARY_UNIT_OF_MEASURE%TYPE;
101: L_TO_UOM MTL_SYSTEM_ITEMS_B.PRIMARY_UNIT_OF_MEASURE%TYPE;
102: BEGIN
103:
104: /* Commented against Bug#12970368

Line 101: L_TO_UOM MTL_SYSTEM_ITEMS_B.PRIMARY_UNIT_OF_MEASURE%TYPE;

97: AND EFF_END_DATE >= V_TRANS_DATE
98: AND DELETE_MARK = 0;
99: X_COST_ORGANIZATION_ID MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
100: L_FROM_UOM MTL_SYSTEM_ITEMS_B.PRIMARY_UNIT_OF_MEASURE%TYPE;
101: L_TO_UOM MTL_SYSTEM_ITEMS_B.PRIMARY_UNIT_OF_MEASURE%TYPE;
102: BEGIN
103:
104: /* Commented against Bug#12970368
105: L_RETURN := GMF_CMCOMMON.GET_PROCESS_ITEM_COST(P_API_VERSION => 1.0

Line 177: MTL_SYSTEM_ITEMS

173: SELECT
174: PRIMARY_UNIT_OF_MEASURE
175: INTO L_FROM_UOM
176: FROM
177: MTL_SYSTEM_ITEMS
178: WHERE INVENTORY_ITEM_ID = UNITCOSTCFFORMULA.INVENTORY_ITEM_ID
179: AND ORGANIZATION_ID = X_COST_ORGANIZATION_ID;
180: EXCEPTION
181: WHEN OTHERS THEN

Line 189: MTL_SYSTEM_ITEMS

185: SELECT
186: PRIMARY_UNIT_OF_MEASURE
187: INTO L_TO_UOM
188: FROM
189: MTL_SYSTEM_ITEMS
190: WHERE INVENTORY_ITEM_ID = UNITCOSTCFFORMULA.INVENTORY_ITEM_ID
191: AND ORGANIZATION_ID = UNITCOSTCFFORMULA.ORGANIZATION_ID;
192: EXCEPTION
193: WHEN OTHERS THEN