APPS.PO_AUTOCREATE_MAINPROC_PVT dependencies on PO_LINES_ALL

Line 80: po_lines_all pla ,

76: INTO po_line_id_tbl ,
77: draft_id_tbl ,
78: delete_flag_tbl
79: FROM po_lines_interface pli ,
80: po_lines_all pla ,
81: po_headers_interface phi
82: WHERE PLI.interface_header_id = po_autocreate_params.g_interface_header_id
83: AND phi.interface_header_id = PLI.interface_header_id
84: AND PLA.po_header_id = PhI.po_header_id

Line 771: po_lines_all pl --

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);
775: --

Line 1148: l_contract_id po_lines_all.contract_id%TYPE;

1144: x_source_doc_line_id NUMBER;
1145: x_consigned_flag VARCHAR2 (1) := 'N';
1146: x_create_new_line VARCHAR2 (1) := 'N';
1147: l_supplier_ref_number po_lines_interface.supplier_ref_number%TYPE;
1148: l_contract_id po_lines_all.contract_id%TYPE;
1149: l_needby_prf VARCHAR2 (1);
1150: l_shipto_prf VARCHAR2 (1);
1151: x_contract_type VARCHAR2 (100);
1152: x_receipt_req_flag VARCHAR2(1);

Line 1806: FROM po_lines_all pol

1802: AND pol2.line_num =
1803: (SELECT
1804: /*+ NO_UNNEST */
1805: MIN (line_num)
1806: FROM po_lines_all pol
1807: --
1808: WHERE pol.po_header_id = poh.po_header_id
1809: AND NVL (cancel_flag, 'N') = 'N'
1810: AND line_type_id = x_line_type_id

Line 2703: l_src_template_id := PO_UDA_AUTOCREATE_PKG.get_template_id ('PO_LINES_ALL' ,

2699: l_progress := '040';
2700: FOR i IN 1..p_po_line_id_tbl.Count
2701: LOOP
2702: l_progress := '080';
2703: l_src_template_id := PO_UDA_AUTOCREATE_PKG.get_template_id ('PO_LINES_ALL' ,
2704: 'PO_LINE_ID' ,
2705: p_po_line_id_tbl(i) ,
2706: NULL,
2707: NULL);

Line 2725: FROM po_lines_all_ext_b ple ,

2721: l_progress := '100';
2722:
2723: SELECT DISTINCT ag.attr_group_name BULK COLLECT
2724: INTO l_attr_group_tbl
2725: FROM po_lines_all_ext_b ple ,
2726: ego_attr_groups_v ag ,
2727: po_uda_ag_template_usages tu
2728: WHERE ple.po_line_id = p_po_line_id_tbl(i)
2729: AND ple.attr_group_id = ag.attr_group_id

Line 2849: FROM po_lines_all_ext_b ple ,

2845: END IF;
2846:
2847: SELECT DISTINCT ag.attr_group_name BULK COLLECT
2848: INTO x_attr_group_tbl
2849: FROM po_lines_all_ext_b ple ,
2850: ego_attr_groups_v ag ,
2851: po_uda_ag_template_usages tu
2852: WHERE ple.po_line_id = p_po_line_id_tbl(i)
2853: AND ple.attr_group_id = ag.attr_group_id