APPS.PO_UDA_AUTOCREATE_PKG dependencies on PO_LINES_ALL

Line 759: l_src_table_name := 'PO_LINES_ALL';

755:
756: ELSIF p_doc_level = 'LINE' THEN
757: x_pk1_col_name := 'PO_LINE_ID';
758: x_pk2_col_name := 'DRAFT_ID';
759: l_src_table_name := 'PO_LINES_ALL';
760:
761: ELSIF p_doc_level = 'SHIPMENT' THEN
762: x_pk1_col_name := 'LINE_LOCATION_ID';
763: x_pk2_col_name := 'DRAFT_ID';

Line 780: l_src_table_name := 'PO_LINES_ALL';

776: l_src_table_name := 'PO_HEADERS_ALL';
777: ELSIF p_doc_level = 'LINE' THEN
778: x_pk1_col_name := 'PO_LINE_ID';
779: x_pk2_col_name := 'DRAFT_ID';
780: l_src_table_name := 'PO_LINES_ALL';
781: ELSIF p_doc_level = 'SHIPMENT' THEN
782: x_pk1_col_name := 'LINE_LOCATION_ID';
783: x_pk2_col_name := 'DRAFT_ID';
784: l_src_table_name := 'PO_LINE_LOCATIONS_ALL';

Line 2668: FROM po_lines_all

2664: AND ea.classification_code = To_Char(pudat.template_id )
2665: AND ead.EXECUTION_METHOD = 'XPD'
2666: AND poh.po_header_id = po_autocreate_params.g_po_header_id
2667: AND pudat.template_id = (SELECT uda_template_id
2668: FROM po_lines_all
2669: WHERE po_header_id = poh.po_header_id
2670: AND ROWNUM < 2) ;
2671:
2672: