DBA Data[Home] [Help]

APPS.GMF_SUBLEDGER_REPORT dependencies on IC_PERD_BAL

Line 497: FROM ic_perd_bal ic

493: /* Begin Bug# 3772552 : Fwd port for 3601833 Added the cursor c_ic_rval_quantity */
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

Line 627: FROM ic_perd_bal ic

623: THEN
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