DBA Data[Home] [Help]

APPS.POS_VALIDATE_ASN dependencies on RCV_SHIPMENT_HEADERS

Line 23: from rcv_shipment_headers

19: /* and shipped_date >= add_months(sysdate,-12) */
20:
21: select count(*)
22: into p_count
23: from rcv_shipment_headers
24: where shipment_num = P_SHIPMENT_NUM
25: and vendor_id = P_VENDOR_ID
26: and nvl(vendor_site_id, -99) = nvl(P_VENDOR_SITE_ID, -99);
27: /* and shipped_date >= add_months(sysdate,-12) */