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.PO_AUTOCREATE_MAINPROC_PVT dependencies on PO_LINES_MERGE_V

Line 1431: po_lines_merge_v pl

1427:
1428: SELECT NVL (MAX (pl.line_num), 0)
1429: INTO x_line_num
1430: FROM po_headers_all ph,
1431: po_lines_merge_v pl
1432: WHERE pl.po_header_id = ph.po_header_id
1433: AND pl.draft_id = PO_AUTOCREATE_PARAMS.g_draft_id
1434: AND ph.segment1 = x_document_num
1435: AND ph.type_lookup_code = x_document_subtype

Line 1659: FROM po_lines_merge_v pol,

1655: SELECT pol.po_line_id,
1656: pol.line_num
1657: INTO x_po_line_id,
1658: x_po_line_num
1659: FROM po_lines_merge_v pol,
1660: po_headers_all poh
1661: WHERE poh.segment1 = x_document_num
1662: AND pol.draft_id = PO_AUTOCREATE_PARAMS.g_draft_id
1663: AND pol.line_num = x_interface_line_num

Line 1783: FROM po_lines_merge_v pol2,

1779: SELECT line_num,
1780: po_line_id
1781: INTO x_po_line_num,
1782: x_po_line_id
1783: FROM po_lines_merge_v pol2,
1784: po_headers_all poh,
1785: po_line_types_b plt --
1786: WHERE poh.segment1 = x_document_num
1787: AND pol2.draft_id = PO_AUTOCREATE_PARAMS.g_draft_id

Line 2106: po_lines_merge_v pl

2102:
2103: SELECT NVL (MAX (pl.line_num), 0)
2104: INTO x_line_num
2105: FROM po_headers_all ph,
2106: po_lines_merge_v pl
2107: WHERE pl.po_header_id = ph.po_header_id
2108: AND pl.draft_id = PO_AUTOCREATE_PARAMS.g_draft_id
2109: AND ph.segment1 = x_document_num
2110: AND NVL (ph.org_id, -99) = NVL (po_autocreate_params.g_purchasing_ou_id, -99)