DBA Data[Home] [Help]

APPS.GMF_SUBLEDGER_REPORT dependencies on GL_SUBR_STA

Line 499: ,gl_subr_sta st

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
503: AND st.reference_no = v_reference_no

Line 629: ,gl_subr_sta st

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
633: AND st.reference_no = r.reference_no