APPS.PO_NEGOTIATIONS_SV1 dependencies on PON_AUC_ITEMS_INTERFACE

Line 1386: --bid_start_price column in pon_auc_items_interface for

1382:
1383: l_progress := '004';
1384: --Bug #2737797
1385: --Amount agreed needs to passed instead of unit_price to
1386: --bid_start_price column in pon_auc_items_interface for
1387: -- amount based lines.
1388:
1389: l_progress := '005';
1390: --Populate PON_AUC_ITEMS_INTERFACE table

Line 1390: --Populate PON_AUC_ITEMS_INTERFACE table

1386: --bid_start_price column in pon_auc_items_interface for
1387: -- amount based lines.
1388:
1389: l_progress := '005';
1390: --Populate PON_AUC_ITEMS_INTERFACE table
1391: insert into pon_auc_items_interface(
1392: interface_auction_header_id,
1393: interface_line_number,
1394: line_type_id,

Line 1391: insert into pon_auc_items_interface(

1387: -- amount based lines.
1388:
1389: l_progress := '005';
1390: --Populate PON_AUC_ITEMS_INTERFACE table
1391: insert into pon_auc_items_interface(
1392: interface_auction_header_id,
1393: interface_line_number,
1394: line_type_id,
1395: item_description,

Line 1515: pon_auc_items_interface paii

1511: pll.last_update_date,
1512: pll.last_updated_by
1513: from po_line_locations pll,
1514: -- bug 2714549: added paii to join; removed join to po_lines
1515: pon_auc_items_interface paii
1516: where pll.po_header_id = p_po_header_id and
1517: --bug 2714549 start: changed join conditions from po_lines
1518: -- to paii and added auction_header cond
1519: -- to ensure unique doc_id/line_id from paii

Line 1659: pon_auc_items_interface paii

1655: fnd_documents fd,
1656: fnd_documents_tl fdtl,
1657: --bug 2714549: replaced join to po_lines
1658: -- with join to paii.
1659: pon_auc_items_interface paii
1660: where fad.document_id = fd.document_id AND
1661: fd.document_id = fdtl.document_id AND
1662: fdtl.language = userenv('LANG') AND
1663: fad.entity_name = 'PO_LINES' AND