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_CONTROL_ACTION_VALIDATIONS dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 5008: po_line_locations_archive_all poall

5004: WHERE pod.line_location_id IN
5005: (SELECT poll.line_location_id
5006: FROM po_session_gt gt,
5007: po_line_locations poll,
5008: po_line_locations_archive_all poall
5009: WHERE gt.key=p_key
5010: AND gt.char1 <> PO_Document_Cancel_PVT.c_doc_type_PA
5011: AND nvl(gt.char5,'Y') <> 'N'
5012: AND poall.line_location_id =poll.line_location_id

Line 5054: po_line_locations_archive_all poall

5050: amount,
5051: need_by_date,
5052: promised_date
5053: FROM
5054: po_line_locations_archive_all poall
5055: WHERE poall.line_location_id =poll.line_location_id
5056: AND poall.latest_external_flag ='Y')
5057: WHERE line_location_id IN
5058: (SELECT *

Line 5162: FROM po_line_locations_archive_all

5158: PO_CORE_S.get_translated_text(
5159: 'PO_CHANGED_CANT_CANCEL_INFO',
5160: 'DOC_LINE_SHIP_DIST_NUM',l_doc_token||gt.char6||','|| l_line_token||pol.LINE_NUM||','||l_ship_token||poll.SHIPMENT_NUM,
5161: 'PRICE_TOKEN',poll.price_override||l_to_token || (SELECT price_override
5162: FROM po_line_locations_archive_all
5163: WHERE latest_external_flag ='Y'
5164: AND line_location_id =poll.line_location_id),
5165: 'AMT_QTY_TOKEN', DECODE(poll.amount,NULL, 'AMOUNT',l_amt_token,l_qty_token),
5166: 'QTY_AMT',Decode(poll.amount,NULL,

Line 5168: FROM po_line_locations_archive_all

5164: AND line_location_id =poll.line_location_id),
5165: 'AMT_QTY_TOKEN', DECODE(poll.amount,NULL, 'AMOUNT',l_amt_token,l_qty_token),
5166: 'QTY_AMT',Decode(poll.amount,NULL,
5167: poll.quantity||l_to_token || (SELECT quantity
5168: FROM po_line_locations_archive_all
5169: WHERE latest_external_flag ='Y'
5170: AND line_location_id =poll.line_location_id),
5171: poll.amount||l_to_token || (SELECT amount
5172: FROM po_line_locations_archive_all

Line 5172: FROM po_line_locations_archive_all

5168: FROM po_line_locations_archive_all
5169: WHERE latest_external_flag ='Y'
5170: AND line_location_id =poll.line_location_id),
5171: poll.amount||l_to_token || (SELECT amount
5172: FROM po_line_locations_archive_all
5173: WHERE latest_external_flag ='Y'
5174: AND line_location_id =poll.line_location_id)
5175: ),
5176: 'NEED_BY_PRM_DATE', Decode(poll.promised_date,NULL,

Line 5178: FROM po_line_locations_archive_all

5174: AND line_location_id =poll.line_location_id)
5175: ),
5176: 'NEED_BY_PRM_DATE', Decode(poll.promised_date,NULL,
5177: poll.need_by_date||l_to_token || (SELECT need_by_date
5178: FROM po_line_locations_archive_all
5179: WHERE latest_external_flag ='Y'
5180: AND line_location_id =poll.line_location_id),
5181: poll.promised_date||l_to_token || (SELECT promised_date
5182: FROM po_line_locations_archive_all

Line 5182: FROM po_line_locations_archive_all

5178: FROM po_line_locations_archive_all
5179: WHERE latest_external_flag ='Y'
5180: AND line_location_id =poll.line_location_id),
5181: poll.promised_date||l_to_token || (SELECT promised_date
5182: FROM po_line_locations_archive_all
5183: WHERE latest_external_flag ='Y'
5184: AND line_location_id =poll.line_location_id)
5185:
5186:

Line 5454: FROM po_line_locations_archive_all

5450: PO_CORE_S.get_translated_text(
5451: 'PO_CHANGED_CANT_CANCEL_ERR',
5452: 'DOC_LINE_SHIP_DIST_NUM',l_doc_token||gt.char6||','|| l_line_token||pol.LINE_NUM||','||l_ship_token||poll.SHIPMENT_NUM,
5453: 'PRICE_TOKEN', (SELECT price_override
5454: FROM po_line_locations_archive_all
5455: WHERE latest_external_flag ='Y'
5456: AND line_location_id =poll.line_location_id)||l_to_token || poll.price_override,
5457: 'AMT_QTY_TOKEN', DECODE(poll.amount,NULL, 'AMOUNT',l_amt_token,l_qty_token),
5458: 'QTY_AMT',Decode(poll.amount,NULL,

Line 5460: FROM po_line_locations_archive_all

5456: AND line_location_id =poll.line_location_id)||l_to_token || poll.price_override,
5457: 'AMT_QTY_TOKEN', DECODE(poll.amount,NULL, 'AMOUNT',l_amt_token,l_qty_token),
5458: 'QTY_AMT',Decode(poll.amount,NULL,
5459: (SELECT quantity
5460: FROM po_line_locations_archive_all
5461: WHERE latest_external_flag ='Y'
5462: AND line_location_id =poll.line_location_id) ||l_to_token || poll.quantity,
5463: (SELECT amount
5464: FROM po_line_locations_archive_all

Line 5464: FROM po_line_locations_archive_all

5460: FROM po_line_locations_archive_all
5461: WHERE latest_external_flag ='Y'
5462: AND line_location_id =poll.line_location_id) ||l_to_token || poll.quantity,
5463: (SELECT amount
5464: FROM po_line_locations_archive_all
5465: WHERE latest_external_flag ='Y'
5466: AND line_location_id =poll.line_location_id) ||l_to_token || poll.amount
5467: ),
5468: 'NEED_BY_PRM_DATE', Decode(poll.promised_date,NULL,

Line 5470: FROM po_line_locations_archive_all

5466: AND line_location_id =poll.line_location_id) ||l_to_token || poll.amount
5467: ),
5468: 'NEED_BY_PRM_DATE', Decode(poll.promised_date,NULL,
5469: (SELECT need_by_date
5470: FROM po_line_locations_archive_all
5471: WHERE latest_external_flag ='Y'
5472: AND line_location_id =poll.line_location_id)||l_to_token||poll.need_by_date ,
5473: (SELECT promised_date
5474: FROM po_line_locations_archive_all

Line 5474: FROM po_line_locations_archive_all

5470: FROM po_line_locations_archive_all
5471: WHERE latest_external_flag ='Y'
5472: AND line_location_id =poll.line_location_id)||l_to_token||poll.need_by_date ,
5473: (SELECT promised_date
5474: FROM po_line_locations_archive_all
5475: WHERE latest_external_flag ='Y'
5476: AND line_location_id =poll.line_location_id)||l_to_token||poll.promised_date
5477:
5478:

Line 5500: FROM po_line_locations_archive_all poall

5496: FROM po_distributions_archive_all
5497: WHERE po_distribution_id =pod.po_distribution_id)
5498: AND Nvl(poll.approved_flag,'N')<>'Y')
5499: OR EXISTS (SELECT 'change exists'
5500: FROM po_line_locations_archive_all poall
5501: WHERE poall.line_location_id =poll.line_location_id
5502: AND poall.latest_external_flag ='Y'
5503: AND (Nvl(poll.price_override,0) <> Nvl(poall.price_override,0)
5504: OR Nvl(poll.quantity,0) <> Nvl(poall.quantity,0)