DBA Data[Home] [Help]

APPS.PO_UDA_AUTOCREATE_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 764: l_src_table_name := 'PO_LINE_LOCATIONS_ALL';

760:
761: ELSIF p_doc_level = 'SHIPMENT' THEN
762: x_pk1_col_name := 'LINE_LOCATION_ID';
763: x_pk2_col_name := 'DRAFT_ID';
764: l_src_table_name := 'PO_LINE_LOCATIONS_ALL';
765:
766: END IF;
767:
768: ELSIF p_doc_type = 'PO' THEN

Line 784: l_src_table_name := 'PO_LINE_LOCATIONS_ALL';

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';
785: END IF;
786:
787: END IF;
788:

Line 2687: FROM po_line_locations_all

2683: AND ea.classification_code = To_Char(pudat.template_id )
2684: AND ead.EXECUTION_METHOD = 'XPD'
2685: AND poh.po_header_id = po_autocreate_params.g_po_header_id
2686: AND pudat.template_id = (SELECT uda_template_id
2687: FROM po_line_locations_all
2688: WHERE po_header_id = poh.po_header_id
2689: AND ROWNUM < 2) ;
2690: END IF;
2691: END IF;