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

Line 200: /* Insert standard POs created against contracts */

196: and nvl(pod.distribution_type,'-99') <> 'AGREEMENT'
197: and pod.creation_date is not null
198: and inc.batch_id = p_batch_no);
199:
200: /* Insert standard POs created against contracts */
201:
202: x_progress := '020';
203: INSERT into poa_bis_savings
204: ( purchase_amount

Line 365: and psc.shipment_type = 'STANDARD'

361: and phc.po_header_id = plc.po_header_id
362: and plc.po_line_id = psc.po_line_id
363: and psc.line_location_id = pod.line_location_id
364: and gl.set_of_books_id = pod.set_of_books_id
365: and psc.shipment_type = 'STANDARD'
366: and plc.contract_id is not null
367: and psc.approved_flag = 'Y'
368: and nvl(pod.distribution_type,'-99') <> 'AGREEMENT'
369: and pod.creation_date is not null

Line 372: /* Insert standard POs created against global agreements */

368: and nvl(pod.distribution_type,'-99') <> 'AGREEMENT'
369: and pod.creation_date is not null
370: and inc.batch_id = p_batch_no);
371:
372: /* Insert standard POs created against global agreements */
373:
374: x_progress := '020';
375: INSERT into poa_bis_savings
376: ( purchase_amount

Line 537: and psc.shipment_type = 'STANDARD'

533: and phc.po_header_id = plc.po_header_id
534: and plc.po_line_id = psc.po_line_id
535: and psc.line_location_id = pod.line_location_id
536: and gl.set_of_books_id = pod.set_of_books_id
537: and psc.shipment_type = 'STANDARD'
538: and plc.from_header_id = ga.po_header_id
539: and ga.global_agreement_flag = 'Y'
540: and nvl(pod.distribution_type,'-99') <> 'AGREEMENT'
541: AND plc.contract_id IS NULL -- in case we have both cpa and ga reference

Line 546: /* Insert standard POs created for Complex work procurement (R12) */

542: and psc.approved_flag = 'Y'
543: and pod.creation_date is not null
544: and inc.batch_id = p_batch_no);
545:
546: /* Insert standard POs created for Complex work procurement (R12) */
547: x_progress := '020';
548:
549: insert into poa_bis_savings
550: (

Line 716: and psc.shipment_type = 'STANDARD'

712: and psc.line_location_id = pod.line_location_id
713: and gl.set_of_books_id = pod.set_of_books_id
714: and phc.style_id = style.style_id
715: and nvl(style.progress_payment_flag,'N') = 'Y'
716: and psc.shipment_type = 'STANDARD'
717: and plc.from_header_id is null
718: and nvl(pod.distribution_type,'-99') <> 'AGREEMENT'
719: AND plc.contract_id IS NULL -- in case we have both cpa reference
720: and psc.approved_flag = 'Y'