DBA Data[Home] [Help]

APPS.GMD_ICR01USR_XMLP_PKG dependencies on FM_MATL_DTL

Line 22: FM_MATL_DTL

18: SELECT
19: LINE_NO
20: INTO P_LINE_NO
21: FROM
22: FM_MATL_DTL
23: WHERE INVENTORY_ITEM_ID = LINE_NOCFFORMULA.ITEM_ID
24: AND LINE_TYPE = 1
25: AND FORMULA_ID = LINE_NOCFFORMULA.FORMULA_ID;
26: EXCEPTION

Line 107: FM_MATL_DTL.INVENTORY_ITEM_ID

103: AND FORMULA_ID = STANDARD_QTYFORMULA.FORMULA_ID
104: AND LEVEL_NUM = STANDARD_QTYFORMULA.LEVEL_NUM
105: AND FM_IBOM_DTL.INVENTORY_ITEM_ID = (
106: SELECT
107: FM_MATL_DTL.INVENTORY_ITEM_ID
108: FROM
109: FM_MATL_DTL
110: WHERE FORMULA_ID = STANDARD_QTYFORMULA.FORMULA_ID
111: AND LINE_TYPE = 1

Line 109: FM_MATL_DTL

105: AND FM_IBOM_DTL.INVENTORY_ITEM_ID = (
106: SELECT
107: FM_MATL_DTL.INVENTORY_ITEM_ID
108: FROM
109: FM_MATL_DTL
110: WHERE FORMULA_ID = STANDARD_QTYFORMULA.FORMULA_ID
111: AND LINE_TYPE = 1
112: AND LINE_NO = 1 )
113: AND LINE_NO = 1;