DBA Data[Home] [Help]

APPS.ARP_ETAX_RECURR_UTIL dependencies on ZX_TRANSACTION_LINES

Line 169: /* Private Procedure - Inserts lines (not tax) into ZX_TRANSACTION_LINES_GT.

165: RAISE;
166:
167: END insert_header;
168:
169: /* Private Procedure - Inserts lines (not tax) into ZX_TRANSACTION_LINES_GT.
170: NOTE: In order for tax to work properly for copied invoices, we
171: must populate the source columns for the copied lines with the
172: data from the original (AR) lines.
173:

Line 203: INSERT INTO ZX_TRANSACTION_LINES_GT

199: /* 4666566 - added support for ship_to and product_org_id to
200: line-level insert. Invoice copy automatically copies ship to
201: to line-level to make it more like autoinvoice. */
202:
203: INSERT INTO ZX_TRANSACTION_LINES_GT
204: (
205: application_id,
206: entity_code,
207: event_class_code,

Line 369: update zx_transaction_lines ZXL

365: END IF;
366:
367: /* 6874006 - removed salesrep/person logic from main insert
368: and shifted it to a separate UPDATE */
369: update zx_transaction_lines ZXL
370: set (poo_party_id, poo_location_id) =
371: (select SR_PER.organization_id, -- poo_party_id
372: SR_HRL.location_id -- poo_location_id
373: from RA_CUSTOMER_TRX TRX,