eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_THIRD_PARTY_STOCK_PVT dependencies on ZX_ITM_DISTRIBUTIONS_GT

Line 698: /* delete from ZX_TRANSACTION_LINES_GT and ZX_ITM_DISTRIBUTIONS_GT

694: /*bug#7120486 delete statement is moved at end after calling ebtax API */
695: /* 5084307 - end */
696:
697: /*5488006 - Start */
698: /* delete from ZX_TRANSACTION_LINES_GT and ZX_ITM_DISTRIBUTIONS_GT
699: before inserting records to prevent duplicate insertion of records -
700: this caused errors in tax calculation */
701: /*bug#7120486 delete statement is moved at end after calling ebtax API */
702:

Line 838: INSERT INTO ZX_ITM_DISTRIBUTIONS_GT

834: ,(SELECT pvs.location_id from po_vendor_sites_all pvs WHERE pvs.vendor_site_id=ph.vendor_site_id) -- bug 14570035
835: FROM po_headers_all ph
836: WHERE ph.po_header_id = p_header_id;
837:
838: INSERT INTO ZX_ITM_DISTRIBUTIONS_GT
839: ( application_id
840: , entity_code
841: , event_class_code
842: -- , event_type_code

Line 986: ZX_ITM_DISTRIBUTIONS_GT

982: in ebTax table.
983: we have to clear following tables :
984: ZX_TRX_HEADERS_GT
985: ZX_TRANSACTION_LINES_GT
986: ZX_ITM_DISTRIBUTIONS_GT
987: */
988:
989: DELETE FROM ZX_TRX_HEADERS_GT
990: WHERE APPLICATION_ID = l_application_id

Line 1001: DELETE FROM ZX_ITM_DISTRIBUTIONS_GT

997: AND ENTITY_CODE = l_entity_code
998: AND EVENT_CLASS_CODE = l_event_class_code
999: AND TRX_ID = p_header_id;
1000:
1001: DELETE FROM ZX_ITM_DISTRIBUTIONS_GT
1002: WHERE APPLICATION_ID = l_application_id
1003: AND ENTITY_CODE = l_entity_code
1004: AND EVENT_CLASS_CODE = l_event_class_code
1005: AND TRX_ID = p_header_id;