APPS.POS_VALIDATE_ASN SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 13

	select count(*)
	into v_temp
	from rcv_headers_interface
	where shipment_num = P_SHIPMENT_NUM
        and vendor_id = P_VENDOR_ID
        and nvl(vendor_site_id, -99) = nvl(P_VENDOR_SITE_ID, -99);

Line: 21

	select count(*)
	into p_count
	from rcv_shipment_headers
	where shipment_num = P_SHIPMENT_NUM
        and vendor_id = P_VENDOR_ID
        and nvl(vendor_site_id, -99) = nvl(P_VENDOR_SITE_ID, -99);

Line: 43

	select count(*)
	into P_COUNT
	from po_lookup_codes
	where lookup_type = 'FREIGHT TERMS'
	and description = P_DESCRIPTION
	and sysdate < nvl(inactive_date, sysdate + 1);

Line: 51

	select lookup_code
	into P_LOOKUP_CODE
	from po_lookup_codes
	where lookup_type = 'FREIGHT TERMS'
	and description = P_DESCRIPTION
	and sysdate < nvl(inactive_date, sysdate + 1);

Line: 69

	SELECT count(*)
	INTO P_COUNT
	FROM org_freight ofg
	WHERE ofg.description = P_DESCRIPTION and
      	-- ofg.organization_id = P_ORGANIZATION_ID and
	nvl(ofg.disable_date, sysdate) <= sysdate;

Line: 77

	SELECT FREIGHT_CODE
	INTO P_FREIGHT_CARRIER_CODE
	FROM org_freight ofg
	WHERE ofg.description = P_DESCRIPTION and
      	-- ofg.organization_id = P_ORGANIZATION_ID and
	nvl(ofg.disable_date, sysdate) <= sysdate;

Line: 94

	SELECT COUNT(*)
	INTO P_COUNT
	FROM ap_terms_val_v
	WHERE NAME = P_NAME;

Line: 101

		SELECT TERM_ID
		INTO P_TERM_ID
		FROM ap_terms_val_v
		WHERE NAME = P_NAME;

Line: 115

	SELECT COUNT(*)
	INTO P_COUNT
	FROM fnd_territories_vl
	WHERE territory_short_name = P_TERRITORY_SHORT_NAME;

Line: 121

		SELECT territory_code
		INTO P_TERRITORY_CODE
		FROM fnd_territories_vl
		WHERE territory_short_name = P_TERRITORY_SHORT_NAME;