DBA Data[Home] [Help]

APPS.PON_CP_INTRFAC_TO_TRANSACTION dependencies on PON_PARTY_LINE_EXCLUSIONS

Line 697: PON_PARTY_LINE_EXCLUSIONS

693: PON_PF_SUPPLIER_VALUES
694: PON_PRICE_ELEMENTS
695: PON_PRICE_DIFFERENTIALS
696: PON_AUCTION_SHIPMENTS_ALL
697: PON_PARTY_LINE_EXCLUSIONS
698: PON_AUC_PAYMENTS_SHIPMENTS
699: Attachments
700: Update backing requisitions for lines being deleted.
701: PON_AUCTION_ITEM_PRICES_ALL

Line 902: --delete from PON_PARTY_LINE_EXCLUSIONS

898: OR paip.group_line_id = p1.auction_line_number
899: OR paip.clm_base_line_num = p1.auction_line_number)
900: and auction_shipments.line_number = p1.auction_line_number);
901:
902: --delete from PON_PARTY_LINE_EXCLUSIONS
903: delete from pon_party_line_exclusions supplier_line_exclusions
904: where
905: auction_header_id = g_auction_header_id
906: and exists

Line 903: delete from pon_party_line_exclusions supplier_line_exclusions

899: OR paip.clm_base_line_num = p1.auction_line_number)
900: and auction_shipments.line_number = p1.auction_line_number);
901:
902: --delete from PON_PARTY_LINE_EXCLUSIONS
903: delete from pon_party_line_exclusions supplier_line_exclusions
904: where
905: auction_header_id = g_auction_header_id
906: and exists
907: (select