DBA Data[Home] [Help]

APPS.INV_THIRD_PARTY_STOCK_PVT dependencies on ZX_ITM_DISTRIBUTIONS_GT

Line 690: /* delete from ZX_TRANSACTION_LINES_GT and ZX_ITM_DISTRIBUTIONS_GT

686: /*bug#7120486 delete statement is moved at end after calling ebtax API */
687: /* 5084307 - end */
688:
689: /*5488006 - Start */
690: /* delete from ZX_TRANSACTION_LINES_GT and ZX_ITM_DISTRIBUTIONS_GT
691: before inserting records to prevent duplicate insertion of records -
692: this caused errors in tax calculation */
693: /*bug#7120486 delete statement is moved at end after calling ebtax API */
694:

Line 828: INSERT INTO ZX_ITM_DISTRIBUTIONS_GT

824: , l_ship_from_location_id
825: FROM po_headers_all
826: WHERE po_header_id = p_header_id;
827:
828: INSERT INTO ZX_ITM_DISTRIBUTIONS_GT
829: ( application_id
830: , entity_code
831: , event_class_code
832: -- , event_type_code

Line 976: ZX_ITM_DISTRIBUTIONS_GT

972: in ebTax table.
973: we have to clear following tables :
974: ZX_TRX_HEADERS_GT
975: ZX_TRANSACTION_LINES_GT
976: ZX_ITM_DISTRIBUTIONS_GT
977: */
978:
979: DELETE FROM ZX_TRX_HEADERS_GT
980: WHERE APPLICATION_ID = l_application_id

Line 991: DELETE FROM ZX_ITM_DISTRIBUTIONS_GT

987: AND ENTITY_CODE = l_entity_code
988: AND EVENT_CLASS_CODE = l_event_class_code
989: AND TRX_ID = p_header_id;
990:
991: DELETE FROM ZX_ITM_DISTRIBUTIONS_GT
992: WHERE APPLICATION_ID = l_application_id
993: AND ENTITY_CODE = l_entity_code
994: AND EVENT_CLASS_CODE = l_event_class_code
995: AND TRX_ID = p_header_id;