APPS.GMD_ICR01USR_XMLP_PKG dependencies on FM_IBOM_DTL

Line 60: FM_IBOM_DTL

56: SELECT
57: SCALE_QTY
58: INTO BATCHQTY
59: FROM
60: FM_IBOM_DTL
61: WHERE TOP_FORMULA_ID = P_FORMULA_ID
62: AND EXPLODE_SEQ = SUBSTR(BATCH_QTYCFFORMULA.EXPLODE_SEQ
63: ,1
64: ,LENGTH(BATCH_QTYCFFORMULA.EXPLODE_SEQ) - 3) || '001';

Line 79: FM_IBOM_DTL

75: SELECT
76: FORMULA_QTY
77: INTO FORMQTY
78: FROM
79: FM_IBOM_DTL
80: WHERE TOP_FORMULA_ID = P_FORMULA_ID
81: AND EXPLODE_SEQ = SUBSTR(FORM_QTYCFFORMULA.EXPLODE_SEQ
82: ,1
83: ,LENGTH(FORM_QTYCFFORMULA.EXPLODE_SEQ) - 3) || '001';

Line 100: FM_IBOM_DTL

96: DISTINCT
97: STD_QTY
98: INTO STANDARDQTY
99: FROM
100: FM_IBOM_DTL
101: WHERE LINE_TYPE = 1
102: AND TOP_FORMULA_ID = P_FORMULA_ID
103: AND FORMULA_ID = STANDARD_QTYFORMULA.FORMULA_ID
104: AND LEVEL_NUM = STANDARD_QTYFORMULA.LEVEL_NUM

Line 105: AND FM_IBOM_DTL.INVENTORY_ITEM_ID = (

101: WHERE LINE_TYPE = 1
102: AND TOP_FORMULA_ID = P_FORMULA_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

Line 128: FM_IBOM_DTL

124: SELECT
125: I_QTY_UOM
126: INTO UOM1
127: FROM
128: FM_IBOM_DTL
129: WHERE TOP_FORMULA_ID = P_FORMULA_ID
130: AND EXPLODE_SEQ = SUBSTR(UOMCFFORMULA.EXPLODE_SEQ
131: ,1
132: ,LENGTH(UOMCFFORMULA.EXPLODE_SEQ) - 3) || '001';