DBA Data[Home] [Help]

APPS.FV_CROSS_DOC_REF dependencies on FV_RECEIPT_MASTER_V

Line 839: SELECT shipment_header_id FROM fv_receipt_master_v frm

835: l_module_name VARCHAR2(200) := g_module_name || 'rec_master';
836: l_errbuf VARCHAR2(1024);
837:
838: CURSOR rec_cur IS
839: SELECT shipment_header_id FROM fv_receipt_master_v frm
840: WHERE shipment_header_id = NVL(vp_shipment_header_id,shipment_header_id)
841: AND TRUNC(receipt_date) = NVL(vp_rec_date,TRUNC(receipt_date))
842: AND vendor_id = vp_vendor_id
843: AND vendor_site_id = vp_vendor_site_id;