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 7473: ,hr_api_transaction_values htv, po_headers_all po_heads

7469: ,hr_api_transaction_values ptv, hr_all_positions_f_tl pos
7470: ,hr_api_transaction_values gtv, per_grades_tl grade
7471: ,hr_api_transaction_values vtv, po_vendors vendor
7472: ,hr_api_transaction_values gltv, ben_pgm_f pgm
7473: ,hr_api_transaction_values htv, po_headers_all po_heads
7474: ,hr_api_transaction_values ltv, po_lines_all po_lines
7475: ,hr_api_transaction_values stv, po_vendor_sites_all vend_sits
7476: ,hr_api_transaction_values btv, hr_lookups hl_bargaining_unit
7477:

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

7550: -- 1.Since we are interested only in poh.segment1 we can
7551: -- drop the rest of the columns and unwanted WHERE clauses from the
7552: -- view po_temp_labor_headers_v
7553: -- 2. The SQL below we have retained all the WHERE clauses
7554: -- dealing with the table po_headers_all, but dropped the rest
7555: -- which are not required in this case.
7556:
7557: SELECT poh.segment1 po_number
7558: FROM

Line 7559: po_headers_all poh

7555: -- which are not required in this case.
7556:
7557: SELECT poh.segment1 po_number
7558: FROM
7559: po_headers_all poh
7560: WHERE
7561: poh.po_header_id = p_id
7562: AND poh.type_lookup_code = 'STANDARD'
7563: AND poh.authorization_status IN ('APPROVED', 'PRE-APPROVED')