DBA Data[Home] [Help]

APPS.PON_SOURCING_OPENAPI_GRP dependencies on PON_AUCTION_SHIPMENTS_ALL

Line 1665: INSERT INTO pon_auction_shipments_all

1661: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1662: ' copying price breaks and price break level price differentials' );
1663: end if;
1664:
1665: INSERT INTO pon_auction_shipments_all
1666: (auction_header_id,
1667: line_number,
1668: shipment_number,
1669: shipment_type,

Line 1708: UPDATE pon_auction_shipments_all

1704: GROUP BY interface_line_number,ship_to_organization_id, ship_to_location_id, quantity;
1705:
1706: -- ADDED FOR SERVICES PROCUREMENT PROJECT
1707: -- Update the price differntials flag based on if their are price differentials at shipments level
1708: UPDATE pon_auction_shipments_all
1709: SET has_price_differentials_flag = 'Y',
1710: differential_response_type = 'OPTIONAL'
1711: WHERE (shipment_number) IN
1712: (SELECT interface_shipment_number