[Home] [Help]
169: RAISE;
170:
171: END insert_header;
172:
173: /* Private Procedure - Inserts lines (not tax) into ZX_TRANSACTION_LINES_GT.
174: NOTE: In order for tax to work properly for copied invoices, we
175: must populate the source columns for the copied lines with the
176: data from the original (AR) lines.
177:
204: line-level insert. Invoice copy automatically copies ship to
205: to line-level to make it more like autoinvoice. */
206: /*Bug 9188841 Changed Query Condition and select*/
207:
208: INSERT INTO ZX_TRANSACTION_LINES_GT
209: (
210: application_id,
211: entity_code,
212: event_class_code,
380: END IF;
381:
382: /* 6874006 - removed salesrep/person logic from main insert
383: and shifted it to a separate UPDATE */
384: update zx_transaction_lines ZXL
385: set (poo_party_id, poo_location_id) =
386: (select SR_PER.organization_id, -- poo_party_id
387: SR_HRL.location_id -- poo_location_id
388: from RA_CUSTOMER_TRX TRX,