APPS.PO_AUTOCREATE_MAINPROC_PVT dependencies on PO_LINE_TYPES

Line 482: po_line_types plt,

478: FROM po_lines_interface pli,
479: po_headers_interface phi,
480: po_requisition_lines_all prl, --
481: mtl_system_items msi,
482: po_line_types plt,
483: po_vendors pov,
484: po_system_parameters_all psp, --
485: financials_system_params_all fsp --
486: WHERE 1 =1

Line 531: PO_LINE_TYPES PLT,

527: FROM PO_LINES_INTERFACE PLI,
528: PO_REQUISITION_LINES_ALL PRL, --
529: --bug 1942696 hr_location changes to reflect the new view
530: MTL_SYSTEM_ITEMS MSI,
531: PO_LINE_TYPES PLT,
532: PO_SYSTEM_PARAMETERS_ALL PSP, --
533: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
534: PO_VENDORS POV,
535: PO_HEADERS_INTERFACE PHI

Line 620: PO_LINE_TYPES PLT,

616: INTO x_po_shipment_num
617: FROM PO_LINES_INTERFACE PLI,
618: PO_REQUISITION_LINES_ALL PRL, --
619: MTL_SYSTEM_ITEMS MSI,
620: PO_LINE_TYPES PLT,
621: PO_SYSTEM_PARAMETERS_ALL PSP, --
622: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
623: PO_VENDORS POV,
624: PO_HEADERS_INTERFACE PHI

Line 1785: po_line_types_b plt --

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
1789: AND NVL (poh.org_id, -99) = NVL (po_autocreate_params.g_purchasing_ou_id, -99)

Line 1893: po_line_types_b plt --

1889: SELECT MIN (pli.line_num)
1890: INTO x_po_line_num
1891: FROM po_lines_interface pli,
1892: po_requisition_lines_all prl,
1893: po_line_types_b plt --
1894: WHERE pli.interface_header_id = x_interface_header_id
1895: AND pli.line_num IS NOT NULL
1896: AND prl.requisition_line_id <> x_requisition_line_id
1897: AND prl.requisition_line_id = pli.requisition_line_id