[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) */