APPS.RCV_HEADERS_INTERFACE_SV dependencies on HR_LOCATIONS_ALL

Line 456: /* Changed hr_locations to hr_locations_all since we are searching

452: AND p_header_record.header_record.location_id IS NULL
453: AND p_header_record.header_record.transaction_type <> 'CANCEL'
454: AND -- added for support of cancel
455: p_header_record.header_record.ship_to_organization_id IS NOT NULL THEN
456: /* Changed hr_locations to hr_locations_all since we are searching
457: * using inventory_organization_id and for drop ship POs inventory
458: * orgid does not have any meaning.
459: */
460: SELECT MAX(hr_locations_all.location_id),

Line 460: SELECT MAX(hr_locations_all.location_id),

456: /* Changed hr_locations to hr_locations_all since we are searching
457: * using inventory_organization_id and for drop ship POs inventory
458: * orgid does not have any meaning.
459: */
460: SELECT MAX(hr_locations_all.location_id),
461: COUNT(*)
462: INTO x_location_id,
463: x_count
464: FROM hr_locations_all

Line 464: FROM hr_locations_all

460: SELECT MAX(hr_locations_all.location_id),
461: COUNT(*)
462: INTO x_location_id,
463: x_count
464: FROM hr_locations_all
465: WHERE hr_locations_all.inventory_organization_id = p_header_record.header_record.ship_to_organization_id
466: AND NVL(hr_locations_all.inactive_date, x_sysdate + 1) > x_sysdate
467: AND NVL(hr_locations_all.receiving_site_flag, 'N') = 'Y';
468:

Line 465: WHERE hr_locations_all.inventory_organization_id = p_header_record.header_record.ship_to_organization_id

461: COUNT(*)
462: INTO x_location_id,
463: x_count
464: FROM hr_locations_all
465: WHERE hr_locations_all.inventory_organization_id = p_header_record.header_record.ship_to_organization_id
466: AND NVL(hr_locations_all.inactive_date, x_sysdate + 1) > x_sysdate
467: AND NVL(hr_locations_all.receiving_site_flag, 'N') = 'Y';
468:
469: IF (g_asn_debug = 'Y') THEN

Line 466: AND NVL(hr_locations_all.inactive_date, x_sysdate + 1) > x_sysdate

462: INTO x_location_id,
463: x_count
464: FROM hr_locations_all
465: WHERE hr_locations_all.inventory_organization_id = p_header_record.header_record.ship_to_organization_id
466: AND NVL(hr_locations_all.inactive_date, x_sysdate + 1) > x_sysdate
467: AND NVL(hr_locations_all.receiving_site_flag, 'N') = 'Y';
468:
469: IF (g_asn_debug = 'Y') THEN
470: asn_debug.put_line('count in hr_locations_all ' || x_count);

Line 467: AND NVL(hr_locations_all.receiving_site_flag, 'N') = 'Y';

463: x_count
464: FROM hr_locations_all
465: WHERE hr_locations_all.inventory_organization_id = p_header_record.header_record.ship_to_organization_id
466: AND NVL(hr_locations_all.inactive_date, x_sysdate + 1) > x_sysdate
467: AND NVL(hr_locations_all.receiving_site_flag, 'N') = 'Y';
468:
469: IF (g_asn_debug = 'Y') THEN
470: asn_debug.put_line('count in hr_locations_all ' || x_count);
471: END IF;

Line 470: asn_debug.put_line('count in hr_locations_all ' || x_count);

466: AND NVL(hr_locations_all.inactive_date, x_sysdate + 1) > x_sysdate
467: AND NVL(hr_locations_all.receiving_site_flag, 'N') = 'Y';
468:
469: IF (g_asn_debug = 'Y') THEN
470: asn_debug.put_line('count in hr_locations_all ' || x_count);
471: END IF;
472:
473: IF x_count = 1 THEN
474: p_header_record.header_record.location_id := x_location_id;

Line 868: hr_locations_all hl, --Bug 5219141. Replace hr_locations by hr_locations_all

864: */
865: SELECT COUNT(*)
866: INTO x_count
867: FROM rcv_transactions_interface rti,
868: hr_locations_all hl, --Bug 5219141. Replace hr_locations by hr_locations_all
869: mtl_parameters org --Replaced org_organization_definitions
870: WHERE rti.header_interface_id = p_header_record.header_record.header_interface_id
871: AND rti.to_organization_code IS NULL
872: AND rti.to_organization_id IS NULL

Line 893: hr_locations_all hl, --Bug 5219141. Replace hr_locations by hr_locations_all

889: IF x_count = 0 THEN
890: SELECT COUNT(*)
891: INTO x_count
892: FROM rcv_transactions_interface rti,
893: hr_locations_all hl, --Bug 5219141. Replace hr_locations by hr_locations_all
894: mtl_parameters org --Replaced org_organization_definitions
895: WHERE rti.header_interface_id = p_header_record.header_record.header_interface_id
896: AND rti.to_organization_code IS NULL
897: AND rti.to_organization_id IS NULL

Line 1598: HR_LOCATIONS_ALL HL, --BUG 5219141 Replaced HR_LOCATIONS

1594:
1595: SELECT MAX(MTL.ORGANIZATION_CODE)
1596: INTO X_TO_ORGANIZATION_CODE
1597: FROM RCV_TRANSACTIONS_INTERFACE RTI,
1598: HR_LOCATIONS_ALL HL, --BUG 5219141 Replaced HR_LOCATIONS
1599: MTL_PARAMETERS MTL
1600: WHERE RTI.HEADER_INTERFACE_ID = X_HEADER_INTERFACE_ID
1601: AND (RTI.SHIP_TO_LOCATION_CODE = HL.LOCATION_CODE
1602: OR RTI.SHIP_TO_LOCATION_ID = HL.LOCATION_ID)