DBA Data[Home] [Help]

APPS.POS_VALIDATE_ASN dependencies on RCV_HEADERS_INTERFACE

Line 15: from rcv_headers_interface

11: BEGIN
12:
13: select count(*)
14: into v_temp
15: from rcv_headers_interface
16: where shipment_num = P_SHIPMENT_NUM
17: and vendor_id = P_VENDOR_ID
18: and nvl(vendor_site_id, -99) = nvl(P_VENDOR_SITE_ID, -99);
19: /* and shipped_date >= add_months(sysdate,-12) */