eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PO_INTERFACE_S dependencies on HR_LOCATIONS

Line 1791: --of hr_locations_all along with inactive date check

1787:
1788: l_progress:= '190';
1789: --bug 4229954
1790: --we will validate a location based on Bill-To-Location and Ship-To-Location flags
1791: --of hr_locations_all along with inactive date check
1792: BEGIN
1793: select 'Y' into x_is_valid
1794: from hr_locations_all
1795: where location_id = x_valid_ship_to

Line 1794: from hr_locations_all

1790: --we will validate a location based on Bill-To-Location and Ship-To-Location flags
1791: --of hr_locations_all along with inactive date check
1792: BEGIN
1793: select 'Y' into x_is_valid
1794: from hr_locations_all
1795: where location_id = x_valid_ship_to
1796: and NVL(ship_to_site_flag, 'N') = 'Y' --bug 4229954
1797: and NVL(trunc(inactive_date),trunc(SYSDATE)+1) > trunc(SYSDATE);
1798:

Line 1821: from hr_locations_all

1817:
1818: l_progress:= '200';
1819: BEGIN
1820: select 'Y' into x_is_valid
1821: from hr_locations_all
1822: where location_id = x_valid_bill_to
1823: and NVL(bill_to_site_flag, 'N') = 'Y' --bug 4229954
1824: and NVL(trunc(inactive_date),trunc(SYSDATE)+1) > trunc(SYSDATE);
1825:

Line 8708: l_ship_to_org_id HR_LOCATIONS_ALL.inventory_organization_id%TYPE;

8704: -- in case of non req back lines from sourcing , ship_to_organization_id is NULL.
8705: -- so get it from distribution interface table.
8706:
8707: --
8708: l_ship_to_org_id HR_LOCATIONS_ALL.inventory_organization_id%TYPE;
8709: --
8710:
8711: BEGIN
8712: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 9642: FROM hr_locations_all hrl

9638: -- SQL WHY: the ship_to_organization is optional from sourcing
9639: BEGIN
9640: SELECT hrl.inventory_organization_id
9641: INTO l_ship_to_org_id
9642: FROM hr_locations_all hrl
9643: WHERE hrl.location_id = i.ship_to_location_id
9644: AND hrl.ship_to_site_flag = 'Y';
9645: EXCEPTION
9646: WHEN no_data_found THEN

Line 11123: from HR_LOCATIONS HRL

11119: )
11120: )
11121: AND ( nvl(l_shipto_prf,'Y') = 'N' -- Bug 3201308
11122: OR exists (select 'x'
11123: from HR_LOCATIONS HRL
11124: where PRL.deliver_to_location_id = HRL.location_id
11125: and nvl(HRL.ship_to_location_id, HRL.location_id) = x_ship_to_location_id
11126: UNION ALL
11127: select 'x'

Line 12350: HZ_LOCATIONS and HR_LOCATIONS and also the corresponding where

12346: ** interface table matches the shipment you are trying to create.
12347: */
12348: /* Bug # 2224446, Added outer join on mtl_system_items */
12349: /* Bug: 2348161.Changed the below SQL and removed the reference to the tables
12350: HZ_LOCATIONS and HR_LOCATIONS and also the corresponding where
12351: clause. Instead added a subquery to check for the location_id
12352: to improve the performance
12353: */
12354: /* Bug 2466578. Changed the UNION to UNION ALL in the sub query to improve the

Line 12404: from HR_LOCATIONS HRL

12400: --added nvl
12401: AND rtrim(nvl(PLI.note_to_receiver,'99')) = rtrim(nvl(x_note_to_receiver,'99'))
12402: --bug 1942696 hr_location changes to reflect the new view
12403: AND exists (select 'x'
12404: from HR_LOCATIONS HRL
12405: where PRL.deliver_to_location_id = HRL.location_id
12406: and nvl(HRL.ship_to_location_id, HRL.location_id) = x_ship_to_location_id
12407: UNION ALL
12408: select 'x'

Line 12478: HZ_LOCATIONS and HR_LOCATIONS and also the corresponding where

12474: ** See if a record that has just been inserted into the
12475: ** interface table matches the shipment you are trying to create.
12476: */
12477: /* Bug: 2348161.Changed the below SQL and removed the reference to the tables
12478: HZ_LOCATIONS and HR_LOCATIONS and also the corresponding where
12479: clause. Instead added a subquery to check for the location_id
12480: to improve the performance
12481: */
12482: SELECT PLI.shipment_num

Line 12524: from HR_LOCATIONS HRL

12520: --added nvl
12521: AND rtrim(nvl(PLI.note_to_receiver,'99')) = rtrim(nvl(x_note_to_receiver,'99'))
12522: --bug 1942696 hr_location changes to reflect the new view
12523: AND exists (select 'x'
12524: from HR_LOCATIONS HRL
12525: where PRL.deliver_to_location_id = HRL.location_id
12526: and nvl(HRL.ship_to_location_id, HRL.location_id) = x_ship_to_location_id
12527: UNION ALL
12528: select 'x'

Line 12597: HZ_LOCATIONS and HR_LOCATIONS and also the corresponding where

12593: end;
12594: IF x_check_doc_sub_type='BID' then
12595:
12596: /* Bug: 2348161.Changed the below SQL and removed the reference to the tables
12597: HZ_LOCATIONS and HR_LOCATIONS and also the corresponding where
12598: clause. Instead added a subquery to check for the location_id
12599: to improve the performance
12600: */
12601:

Line 12651: from HR_LOCATIONS HRL

12647: (PLI.need_by_date is NULL AND x_need_by_date is NULL)
12648: )
12649: --bug 1942696 hr_location changes to reflect the new view
12650: AND exists (select 'x'
12651: from HR_LOCATIONS HRL
12652: where PRL.deliver_to_location_id = HRL.location_id
12653: and nvl(HRL.ship_to_location_id, HRL.location_id) = x_ship_to_location_id
12654: UNION ALL
12655: select 'x'

Line 13497: FROM hr_locations hrl

13493: BEGIN
13494:
13495: SELECT NVL(hrl.ship_to_location_id, hrl.location_id)
13496: INTO l_ship_to_location_id
13497: FROM hr_locations hrl
13498: WHERE hrl.location_id = p_deliver_to_loc_id;
13499:
13500: l_found := TRUE;
13501:

Line 13505: PO_LOG.stmt(d_module, d_progress, 'No data found in hr_locations.');

13501:
13502: EXCEPTION
13503: WHEN NO_DATA_FOUND THEN
13504: IF (PO_LOG.d_stmt) THEN
13505: PO_LOG.stmt(d_module, d_progress, 'No data found in hr_locations.');
13506: END IF;
13507: END;
13508:
13509: d_progress := 20;