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
20: AND D.BATCH_ID = H.BATCH_ID
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
210: AND D.BATCH_ID = H.BATCH_ID
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
241: AND D.BATCH_ID = H.BATCH_ID