DBA Data[Home] [Help]

APPS.GMI_ICR03_XMLP_PKG dependencies on PM_BTCH_HDR

Line 15: PM_BTCH_HDR H,

11: H.BATCH_NO
12: INTO D_NO
13: FROM
14: PM_MATL_DTL D,
15: PM_BTCH_HDR H,
16: FM_FORM_MST F
17: WHERE D.BATCH_ID = DOC_ID
18: AND D.LINE_ID = LINE_ID1
19: AND D.ITEM_ID = ITEM_ID1

Line 205: PM_BTCH_HDR H,

201: F.FORMULA_NO
202: INTO F_NO
203: FROM
204: PM_MATL_DTL D,
205: PM_BTCH_HDR H,
206: FM_FORM_MST F
207: WHERE D.BATCH_ID = DOC_ID
208: AND D.LINE_ID = LINE_ID1
209: AND D.ITEM_ID = ITEM_ID1

Line 236: PM_BTCH_HDR H,

232: F.FORMULA_VERS
233: INTO V_NO
234: FROM
235: PM_MATL_DTL D,
236: PM_BTCH_HDR H,
237: FM_FORM_MST F
238: WHERE D.BATCH_ID = DOC_ID
239: AND D.LINE_ID = LINE_ID1
240: AND D.ITEM_ID = ITEM_ID1