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 220: decode(plls.shipment_type,'PREPAYMENT','PREPAYMENT','STANDARD') shipment_type,

216: NVL(NVL(plls.terms_id, phs.terms_id) , pvss2.terms_id) payment_terms_id,
217: DECODE(plls.taxable_flag, 'Y', plls.tax_code_id, NULL) tax_code_id,
218: nvl(plls.description, pls.item_description) item_description,--bug7658186
219: plls.matching_basis,
220: decode(plls.shipment_type,'PREPAYMENT','PREPAYMENT','STANDARD') shipment_type,
221: NVL(rsl.osa_flag,'N') osa_flag, --Shikyu project
222: plls.match_option, -- 5100177
223: rts.unit_of_measure, -- 5100177
224: plls.unit_meas_lookup_code -- 5100177

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

311: NVL(NVL(plls.terms_id, phs.terms_id) , pvss2.terms_id) payment_terms_id,
312: DECODE(plls.taxable_flag, 'Y', plls.tax_code_id, NULL) tax_code_id,
313: nvl(plls.description, pls.item_description) item_description,--bug7658186
314: plls.matching_basis,
315: decode(plls.shipment_type,'PREPAYMENT','PREPAYMENT','STANDARD') shipment_type,
316: NVL(rsl.osa_flag,'N') osa_flag, --Shikyu project
317: plls.match_option, -- 5100177
318: rts.unit_of_measure, -- 5100177
319: plls.unit_meas_lookup_code -- 5100177

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

370: rts.currency_code,
371: payment_terms_id,
372: trunc(rts.transaction_date), --Bug 10168386
373: pack_slip,
374: decode(plls.shipment_type,'PREPAYMENT','PREPAYMENT','STANDARD'),
375: rsh.shipment_header_id,
376: rsl.osa_flag; --Shikyu project*/
377:
378: /* R12 Complex Work.

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

377:
378: /* R12 Complex Work.
379: * Added plls.shipment_type so that we create separate invoices
380: * for Prepayment shipments. For other valid shipments like
381: * Standard and Blanket continue as is and can be grouped
382: * in one invoice.
383: */
384: /***** Cursor declaration ****/
385: CURSOR C_receipt_txns2 IS

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

426: NVL(NVL(plls.terms_id, phs.terms_id) , pvss2.terms_id) payment_terms_id,
427: DECODE(plls.taxable_flag, 'Y', plls.tax_code_id, NULL) tax_code_id,
428: nvl(plls.description, pls.item_description) item_description,--bug7658186
429: plls.matching_basis,
430: decode(plls.shipment_type,'PREPAYMENT','PREPAYMENT','STANDARD')shipment_type,
431: rsl.osa_flag, --Shikyu project
432: plls.match_option, -- 5100177
433: rts.unit_of_measure, -- 5100177
434: plls.unit_meas_lookup_code -- 5100177

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

480: rts.currency_code,
481: payment_terms_id,
482: txn_date, --Bug 10168386
483: pack_slip,
484: decode(plls.shipment_type,'PREPAYMENT','PREPAYMENT','STANDARD'),
485: rsh.shipment_header_id, --Bug 6822389
486: rsl.osa_flag; --Shikyu project
487:
488:

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

899: changed in the cursor. */
900:
901: /* R12 Complex Work.
902: * Compare shipment_types and if they are different then create
903: * a new invoice. Here we will have Standard for all the other
904: * shipment_types other than prepayment as we want to group
905: * them together.
906: */
907: