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.PO_INVOICES_SV2 dependencies on STANDARD

Line 154: * Standard and Blanket continue as is and can be grouped

150: /***** Cursor declaration ****/
151: /* R12 Complex Work.
152: * Added plls.shipment_type so that we create separate invoices
153: * for Prepayment shipments. For other valid shipments like
154: * Standard and Blanket continue as is and can be grouped
155: * in one invoice.
156: */
157:
158: /* Bug 5388926 : Changed order by clause in both cursors.

Line 210: decode(plls.shipment_type,'PREPAYMENT','PREPAYMENT','STANDARD') shipment_type,

206: NVL(NVL(plls.terms_id, phs.terms_id) , pvss2.terms_id) payment_terms_id,
207: DECODE(plls.taxable_flag, 'Y', plls.tax_code_id, NULL) tax_code_id,
208: pls.item_description,
209: plls.matching_basis,
210: decode(plls.shipment_type,'PREPAYMENT','PREPAYMENT','STANDARD') shipment_type,
211: NVL(rsl.osa_flag,'N') osa_flag, --Shikyu project
212: plls.match_option, -- 5100177
213: rts.unit_of_measure, -- 5100177
214: plls.unit_meas_lookup_code -- 5100177

Line 288: decode(plls.shipment_type,'PREPAYMENT','PREPAYMENT','STANDARD') shipment_type,

284: NVL(NVL(plls.terms_id, phs.terms_id) , pvss2.terms_id) payment_terms_id,
285: DECODE(plls.taxable_flag, 'Y', plls.tax_code_id, NULL) tax_code_id,
286: pls.item_description,
287: plls.matching_basis,
288: decode(plls.shipment_type,'PREPAYMENT','PREPAYMENT','STANDARD') shipment_type,
289: NVL(rsl.osa_flag,'N') osa_flag, --Shikyu project
290: plls.match_option, -- 5100177
291: rts.unit_of_measure, -- 5100177
292: plls.unit_meas_lookup_code -- 5100177

Line 340: decode(plls.shipment_type,'PREPAYMENT','PREPAYMENT','STANDARD'),

336: rts.currency_code,
337: payment_terms_id,
338: rts.transaction_date,
339: pack_slip,
340: decode(plls.shipment_type,'PREPAYMENT','PREPAYMENT','STANDARD'),
341: rsh.shipment_header_id,
342: rsl.osa_flag; --Shikyu project*/
343:
344: /* R12 Complex Work.

Line 347: * Standard and Blanket continue as is and can be grouped

343:
344: /* R12 Complex Work.
345: * Added plls.shipment_type so that we create separate invoices
346: * for Prepayment shipments. For other valid shipments like
347: * Standard and Blanket continue as is and can be grouped
348: * in one invoice.
349: */
350: /***** Cursor declaration ****/
351: CURSOR C_receipt_txns2 IS

Line 386: decode(plls.shipment_type,'PREPAYMENT','PREPAYMENT','STANDARD')shipment_type,

382: NVL(NVL(plls.terms_id, phs.terms_id) , pvss2.terms_id) payment_terms_id,
383: DECODE(plls.taxable_flag, 'Y', plls.tax_code_id, NULL) tax_code_id,
384: pls.item_description,
385: plls.matching_basis,
386: decode(plls.shipment_type,'PREPAYMENT','PREPAYMENT','STANDARD')shipment_type,
387: rsl.osa_flag, --Shikyu project
388: plls.match_option, -- 5100177
389: rts.unit_of_measure, -- 5100177
390: plls.unit_meas_lookup_code -- 5100177

Line 433: decode(plls.shipment_type,'PREPAYMENT','PREPAYMENT','STANDARD'),

429: rts.currency_code,
430: payment_terms_id,
431: rts.transaction_date,
432: pack_slip,
433: decode(plls.shipment_type,'PREPAYMENT','PREPAYMENT','STANDARD'),
434: rsh.shipment_header_id, --Bug 6822389
435: rsl.osa_flag; --Shikyu project
436:
437:

Line 852: * a new invoice. Here we will have Standard for all the other

848: changed in the cursor. */
849:
850: /* R12 Complex Work.
851: * Compare shipment_types and if they are different then create
852: * a new invoice. Here we will have Standard for all the other
853: * shipment_types other than prepayment as we want to group
854: * them together.
855: */
856: