DBA Data[Home] [Help]

APPS.GML_AUDIT_REPORTS dependencies on IC_ITEM_MST

Line 230: l_gms_itm ic_item_mst.item_no%TYPE;

226:
227: FUNCTION chk_ofi_gms_poln_itm( p_olid NUMBER,
228: p_glid NUMBER) RETURN VARCHAR2 IS
229:
230: l_gms_itm ic_item_mst.item_no%TYPE;
231: l_ofi_itm mtl_system_items.segment1%TYPE;
232:
233: CURSOR gms_itm_cur IS
234: SELECT a.item_no

Line 235: FROM ic_item_mst a,

231: l_ofi_itm mtl_system_items.segment1%TYPE;
232:
233: CURSOR gms_itm_cur IS
234: SELECT a.item_no
235: FROM ic_item_mst a,
236: po_ordr_dtl b
237: WHERE a.item_id=b.item_id
238: AND b.line_id=p_glid;
239: