DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_MAINPROC_PVT dependencies on PO_LINE_TYPES_B

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