APPS.PO_AUTOCREATE_MAINPROC_PVT dependencies on PO_HEADERS_ALL

Line 95: FROM po_headers_all

91: );
92:
93: --
94: SELECT style_id INTO l_style_id
95: FROM po_headers_all
96: WHERE po_header_id = po_autocreate_params.g_po_header_id;
97:
98: IF g_debug_stmt THEN
99: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

Line 770: FROM po_headers_all ph, --

766: l_progress := '030';
767:
768: SELECT NVL (MAX (line_num), 0)
769: INTO x_line_num
770: FROM po_headers_all ph, --
771: po_lines_all pl --
772: WHERE pl.po_header_id = ph.po_header_id
773: AND ph.segment1 = x_document_num
774: AND NVL (ph.org_id, -99) = NVL (po_autocreate_params.g_purchasing_ou_id, -99);

Line 823: FROM po_headers_all ph, --

819:
820: l_progress := '080';
821: SELECT NVL (MAX (shipment_num), 0)
822: INTO x_shipment_num
823: FROM po_headers_all ph, --
824: po_line_locations_all poll, --
825: po_releases_all pr --
826: WHERE ph.po_header_id = poll.po_header_id
827: AND ph.segment1 = x_document_num

Line 1430: FROM po_headers_all ph,

1426: END IF;
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

Line 1660: po_headers_all poh

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
1664: AND poh.type_lookup_code = x_document_subtype

Line 1784: po_headers_all poh,

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
1788: AND poh.po_header_id = pol2.po_header_id

Line 2105: FROM po_headers_all ph,

2101: END IF;
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