APPS.GML_RECV_TRANS_PKG dependencies on IC_ITEM_MST

Line 822: v_opm_item_id ic_item_mst.item_id%TYPE;

818: v_line_no po_ordr_dtl.line_no%TYPE;
819: v_orgn_code po_ordr_hdr.orgn_code%TYPE;
820: v_returned_qty po_rtrn_dtl.return_qty1%TYPE;
821:
822: v_opm_item_id ic_item_mst.item_id%TYPE;
823: v_opm_item_no ic_item_mst.item_no%TYPE;
824:
825: v_apps_po_header_id po_headers_all.po_header_id%TYPE;
826: v_vendor_site_id po_headers_all.vendor_site_id%TYPE;

Line 823: v_opm_item_no ic_item_mst.item_no%TYPE;

819: v_orgn_code po_ordr_hdr.orgn_code%TYPE;
820: v_returned_qty po_rtrn_dtl.return_qty1%TYPE;
821:
822: v_opm_item_id ic_item_mst.item_id%TYPE;
823: v_opm_item_no ic_item_mst.item_no%TYPE;
824:
825: v_apps_po_header_id po_headers_all.po_header_id%TYPE;
826: v_vendor_site_id po_headers_all.vendor_site_id%TYPE;
827: v_freight_terms po_headers_all.freight_terms_lookup_code%TYPE;

Line 946: FROM ic_item_mst

942: line_location_id = vc_apps_po_line_location_id;
943:
944: CURSOR opm_item_cur(vc_opm_item_id NUMBER) IS
945: SELECT item_no
946: FROM ic_item_mst
947: WHERE item_id = vc_opm_item_id;
948:
949: CURSOR app_item_cur(vc_opm_item_no VARCHAR2) IS
950: SELECT inventory_item_id,description