DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_PO_PKG dependencies on HR_LOCATIONS_ALL

Line 454: hr_locations_all hr

450: fnd_currencies fc,
451: po_lines_all pol,
452: po_line_locations_all poll,
453: zx_party_tax_profile ptp,
454: hr_locations_all hr
455: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)
456: AND pol.po_header_id = poh.po_header_id
457: AND poll.po_header_id = pol.po_header_id
458: AND poll.po_line_id = pol.po_line_id

Line 2763: hr_locations_all hr

2759: ) poll,
2760: fnd_currencies fc,
2761: po_lines_all pol,
2762: zx_party_tax_profile ptp,
2763: hr_locations_all hr
2764: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)
2765: AND pol.po_header_id = poll.po_header_id
2766: AND pol.po_line_id = poll.po_line_id
2767: AND hr.location_id(+) = poll.ship_to_location_id

Line 5165: hr_locations_all hr

5161: fnd_currencies fc,
5162: po_lines_all pol,
5163: po_line_locations_all poll,
5164: zx_party_tax_profile ptp,
5165: hr_locations_all hr
5166: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)
5167: AND pol.po_header_id = poh.po_header_id
5168: AND poll.po_header_id = pol.po_header_id
5169: AND poll.po_line_id = pol.po_line_id

Line 7461: hr_locations_all hr

7457: ) poll,
7458: fnd_currencies fc,
7459: po_lines_all pol,
7460: zx_party_tax_profile ptp,
7461: hr_locations_all hr
7462: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)
7463: AND pol.po_header_id = poll.po_header_id
7464: AND pol.po_line_id = poll.po_line_id
7465: AND hr.location_id(+) = poll.ship_to_location_id