DBA Data[Home] [Help]

APPS.GMF_SUBLEDGER_REPORT dependencies on IC_WHSE_MST

Line 498: ,ic_whse_mst wh

494: CURSOR c_ic_rval_quantity(v_doc_id NUMBER,v_line_id NUMBER,
495: v_reference_no NUMBER) IS
496: SELECT sum(ic.loct_onhand)
497: FROM ic_perd_bal ic
498: ,ic_whse_mst wh
499: ,gl_subr_sta st
500: WHERE ic.whse_code = wh.whse_code
501: AND wh.mtl_organization_id = v_doc_id
502: AND ic.item_id = v_line_id

Line 628: ,ic_whse_mst wh

624: /************* Bug 3772552****************/
625: /*SELECT sum(ic.loct_onhand)
626: INTO l_quantity
627: FROM ic_perd_bal ic
628: ,ic_whse_mst wh
629: ,gl_subr_sta st
630: WHERE ic.whse_code = wh.whse_code
631: AND wh.mtl_organization_id = r.doc_id
632: AND ic.item_id = r.line_id