DBA Data[Home] [Help]

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: L_RETURN := GMF_CMCOMMON.GET_PROCESS_ITEM_COST(P_API_VERSION => 1.0
104: ,P_INIT_MSG_LIST => NULL

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: L_RETURN := GMF_CMCOMMON.GET_PROCESS_ITEM_COST(P_API_VERSION => 1.0
104: ,P_INIT_MSG_LIST => NULL
105: ,X_RETURN_STATUS => L_RETURN_STATUS

Line 130: MTL_SYSTEM_ITEMS

126: SELECT
127: PRIMARY_UNIT_OF_MEASURE
128: INTO L_FROM_UOM
129: FROM
130: MTL_SYSTEM_ITEMS
131: WHERE INVENTORY_ITEM_ID = UNITCOSTCFFORMULA.INVENTORY_ITEM_ID
132: AND ORGANIZATION_ID = X_COST_ORGANIZATION_ID;
133: EXCEPTION
134: WHEN OTHERS THEN

Line 142: MTL_SYSTEM_ITEMS

138: SELECT
139: PRIMARY_UNIT_OF_MEASURE
140: INTO L_TO_UOM
141: FROM
142: MTL_SYSTEM_ITEMS
143: WHERE INVENTORY_ITEM_ID = UNITCOSTCFFORMULA.INVENTORY_ITEM_ID
144: AND ORGANIZATION_ID = UNITCOSTCFFORMULA.ORGANIZATION_ID;
145: EXCEPTION
146: WHEN OTHERS THEN