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.

APPS.HR_PROCESS_ASSIGNMENT_SS dependencies on PO_HEADERS_ALL

Line 664: -- dealing with the table po_headers_all, but dropped the rest

660: -- 1.Since we are interested only in poh.segment1 we can
661: -- drop the rest of the columns and unwanted WHERE clauses from the
662: -- view po_temp_labor_headers_v
663: -- 2. The SQL below we have retained all the WHERE clauses
664: -- dealing with the table po_headers_all, but dropped the rest
665: -- which are not required in this case.
666:
667: SELECT poh.segment1 po_number
668: FROM

Line 669: po_headers_all poh

665: -- which are not required in this case.
666:
667: SELECT poh.segment1 po_number
668: FROM
669: po_headers_all poh
670: WHERE
671: poh.po_header_id = p_id
672: AND poh.type_lookup_code = 'STANDARD'
673: AND poh.authorization_status IN ('APPROVED', 'PRE-APPROVED')

Line 7956: ,hr_api_transaction_values htv, po_headers_all po_heads

7952: ,hr_api_transaction_values ptv, hr_all_positions_f_tl pos
7953: ,hr_api_transaction_values gtv, per_grades_tl grade
7954: ,hr_api_transaction_values vtv, po_vendors vendor
7955: ,hr_api_transaction_values gltv, ben_pgm_f pgm
7956: ,hr_api_transaction_values htv, po_headers_all po_heads
7957: ,hr_api_transaction_values ltv, po_lines_all po_lines
7958: ,hr_api_transaction_values stv, po_vendor_sites_all vend_sits
7959: ,hr_api_transaction_values btv, hr_lookups hl_bargaining_unit
7960:

Line 8037: -- dealing with the table po_headers_all, but dropped the rest

8033: -- 1.Since we are interested only in poh.segment1 we can
8034: -- drop the rest of the columns and unwanted WHERE clauses from the
8035: -- view po_temp_labor_headers_v
8036: -- 2. The SQL below we have retained all the WHERE clauses
8037: -- dealing with the table po_headers_all, but dropped the rest
8038: -- which are not required in this case.
8039:
8040: SELECT poh.segment1 po_number
8041: FROM

Line 8042: po_headers_all poh

8038: -- which are not required in this case.
8039:
8040: SELECT poh.segment1 po_number
8041: FROM
8042: po_headers_all poh
8043: WHERE
8044: poh.po_header_id = p_id
8045: AND poh.type_lookup_code = 'STANDARD'
8046: AND poh.authorization_status IN ('APPROVED', 'PRE-APPROVED')