DBA Data[Home] [Help]

APPS.PON_CP_INTRFAC_TO_TRANSACTION dependencies on PON_PARTY_LINE_EXCLUSIONS

Line 692: PON_PARTY_LINE_EXCLUSIONS

688: PON_PF_SUPPLIER_VALUES
689: PON_PRICE_ELEMENTS
690: PON_PRICE_DIFFERENTIALS
691: PON_AUCTION_SHIPMENTS_ALL
692: PON_PARTY_LINE_EXCLUSIONS
693: PON_AUC_PAYMENTS_SHIPMENTS
694: Attachments
695: Update backing requisitions for lines being deleted.
696: PON_AUCTION_ITEM_PRICES_ALL

Line 878: --delete from PON_PARTY_LINE_EXCLUSIONS

874: (paip.parent_line_number = p1.auction_line_number
875: and paip.group_type in ('LOT_LINE','GROUP_LINE')))
876: and auction_shipments.line_number = p1.auction_line_number);
877:
878: --delete from PON_PARTY_LINE_EXCLUSIONS
879: delete from pon_party_line_exclusions supplier_line_exclusions
880: where
881: auction_header_id = g_auction_header_id
882: and exists

Line 879: delete from pon_party_line_exclusions supplier_line_exclusions

875: and paip.group_type in ('LOT_LINE','GROUP_LINE')))
876: and auction_shipments.line_number = p1.auction_line_number);
877:
878: --delete from PON_PARTY_LINE_EXCLUSIONS
879: delete from pon_party_line_exclusions supplier_line_exclusions
880: where
881: auction_header_id = g_auction_header_id
882: and exists
883: (select