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

Line 200: po_line_locations poll,

196: 'DOC_NUM',gt.char6),
197: gt.num1,
198: gt.char3
199: FROM
200: po_line_locations poll,
201: po_lines pol ,
202: po_session_gt gt
203: WHERE gt.key=p_key
204: AND poll.line_location_id = gt.index_num1 -- lowestentityid i.e.

Line 524: FROM po_line_locations poll

520: DECODE(
521: pol.amount,
522: null,
523: (SELECT Sum(poll.quantity - nvl(poll.quantity_cancelled,0))
524: FROM po_line_locations poll
525: WHERE poll.po_line_id = pol.po_line_id ),
526: (SELECT sum(poll.amount - nvl(poll.amount_cancelled,0))
527: FROM po_line_locations poll
528: WHERE poll.po_line_id = pol.po_line_id )),

Line 527: FROM po_line_locations poll

523: (SELECT Sum(poll.quantity - nvl(poll.quantity_cancelled,0))
524: FROM po_line_locations poll
525: WHERE poll.po_line_id = pol.po_line_id ),
526: (SELECT sum(poll.amount - nvl(poll.amount_cancelled,0))
527: FROM po_line_locations poll
528: WHERE poll.po_line_id = pol.po_line_id )),
529: 'DOC_NUM',(SELECT segment1 FROM po_headers WHERE po_header_id=pol.po_header_id)),
530: (SELECT gt.num1
531: FROM po_session_gt gt

Line 563: FROM po_line_locations,

559: po_lines pol
560: WHERE
561: pol.po_line_id IN
562: (SELECT DISTINCT po_line_id
563: FROM po_line_locations,
564: po_session_gt gt
565: WHERE gt.KEY=p_key
566: AND line_location_id= gt.index_num1 -- lowestentityid)
567: AND gt.char1 = po_document_cancel_pvt.c_doc_type_PO

Line 572: FROM po_line_locations poll

568: AND gt.char3<> po_document_cancel_pvt.c_entity_level_SHIPMENT)
569:
570: AND ((POL.quantity IS NOT null
571: AND pol.quantity <> (SELECT Sum(poll.quantity - nvl(poll.quantity_cancelled,0))
572: FROM po_line_locations poll
573: WHERE poll.po_line_id = pol.po_line_id))
574: OR
575: (POL.amount IS NOT null
576: AND pol.amount <> (SELECT sum(poll.amount- nvl(poll.amount_cancelled,0))

Line 577: FROM po_line_locations poll

573: WHERE poll.po_line_id = pol.po_line_id))
574: OR
575: (POL.amount IS NOT null
576: AND pol.amount <> (SELECT sum(poll.amount- nvl(poll.amount_cancelled,0))
577: FROM po_line_locations poll
578: WHERE poll.po_line_id = pol.po_line_id )))
579: );
580:
581:

Line 730: po_line_locations poll,

726: gt.char6),
727: gt.num1,
728: gt.char3
729: FROM
730: po_line_locations poll,
731: po_lines pol ,
732: po_session_gt gt
733: WHERE
734: gt.key=p_key

Line 910: po_line_locations poll,

906: ),
907: gt.num1,
908: gt.char3
909: FROM
910: po_line_locations poll,
911: po_lines pol ,
912: po_session_gt gt
913: WHERE
914: gt.key=p_key

Line 1086: po_line_locations poll,

1082: ),
1083: gt.num1,
1084: gt.char3
1085: FROM
1086: po_line_locations poll,
1087: po_lines pol ,
1088: po_session_gt gt
1089: WHERE
1090: gt.key=p_key

Line 1255: po_line_locations poll,

1251: gt.num1,
1252: gt.char3
1253: FROM
1254: po_distributions_all pod,
1255: po_line_locations poll,
1256: po_lines pol ,
1257: po_session_gt gt
1258: WHERE
1259: gt.key=p_key

Line 1430: po_line_locations poll,

1426: gt.num1,
1427: gt.char3
1428: FROM
1429: po_distributions pod,
1430: po_line_locations poll,
1431: po_lines pol,
1432: po_session_gt gt
1433: WHERE
1434: gt.key=p_key

Line 1617: po_line_locations poll,

1613: gt.num1,
1614: gt.char3
1615: FROM
1616: po_distributions pod,
1617: po_line_locations poll,
1618: po_lines pol,
1619: po_session_gt gt
1620: WHERE
1621: gt.key=p_key

Line 1815: po_line_locations poll,

1811: ),
1812: gt.num1,
1813: gt.char3
1814: FROM
1815: po_line_locations poll,
1816: po_lines pol,
1817: po_session_gt gt
1818: WHERE gt.key=p_key
1819: AND poll.line_location_id = gt.index_num1

Line 2007: po_line_locations poll,

2003: gt.num1,
2004: gt.char3
2005: FROM
2006: po_distributions pod,
2007: po_line_locations poll,
2008: po_lines pol,
2009: po_session_gt gt
2010: WHERE
2011: gt.key=p_key

Line 2210: po_line_locations poll,

2206: ),
2207: gt.num1,
2208: gt.char3
2209: FROM
2210: po_line_locations poll,
2211: po_lines pol,
2212: po_session_gt gt
2213:
2214: WHERE gt.KEY =p_key

Line 2371: po_line_locations poll,

2367: ),
2368: gt.num1,
2369: gt.char3
2370: FROM
2371: po_line_locations poll,
2372: po_lines pol,
2373: po_session_gt gt
2374: WHERE
2375: gt.key=p_key

Line 2527: po_line_locations poll,

2523: ),
2524: gt.num1,
2525: gt.char3
2526: FROM
2527: po_line_locations poll,
2528: po_lines pol,
2529: po_session_gt gt
2530: WHERE gt.key=p_key
2531: AND poll.line_location_id =gt.index_num1

Line 2694: po_line_locations poll,

2690: gt.num1,
2691: gt.char3
2692: FROM
2693: po_distributions pod,
2694: po_line_locations poll,
2695: po_lines pol,
2696: po_session_gt gt,
2697: FINANCIALS_SYSTEM_PARAMETERS FSP,
2698: gl_code_combinations gcc

Line 2863: po_line_locations poll,

2859: gt.num1,
2860: gt.char3
2861: FROM
2862: po_distributions pod,
2863: po_line_locations poll,
2864: po_lines pol,
2865: gl_code_combinations gcc,
2866: po_session_gt gt
2867: WHERE gt.key=p_key

Line 3186: FROM PO_LINE_LOCATIONS PLL

3182: -- bug 16174863
3183: AND gt.char1 = po_document_cancel_pvt.c_doc_type_PA
3184: AND EXISTS
3185: (SELECT 'Uncancelled Releases Exist'
3186: FROM PO_LINE_LOCATIONS PLL
3187: WHERE PLL.po_line_id = POL.po_line_id
3188: AND PLL.shipment_type in ('BLANKET')
3189: AND nvl(PLL.cancel_flag,'N') = 'N'
3190: AND nvl(PLL.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 3237: po_line_locations poll,

3233: gt.num1,
3234: gt.char3
3235: FROM
3236: po_lines pol,
3237: po_line_locations poll,
3238: po_session_gt gt
3239: WHERE gt.key=p_key
3240: AND poll.LINE_LOCATION_ID =gt.index_num1
3241: AND pol.po_line_id =poll.po_line_id

Line 3245: FROM PO_LINE_LOCATIONS PLL

3241: AND pol.po_line_id =poll.po_line_id
3242: AND gt.char2 = po_document_cancel_pvt.c_doc_subtype_PLANNED
3243: AND EXISTS(
3244: SELECT 'Uncancelled Releases Exist'
3245: FROM PO_LINE_LOCATIONS PLL
3246: WHERE
3247: PLL.SOURCE_SHIPMENT_ID = POLL.LINE_LOCATION_ID
3248: AND PLL.shipment_type in ('SCHEDULED')
3249: AND nvl(PLL.cancel_flag,'N') = 'N'

Line 3649: FROM po_line_locations poll,

3645: FROM po_headers
3646: WHERE po_header_id=poll.po_header_id)
3647: ),
3648: date1
3649: FROM po_line_locations poll,
3650: po_session_gt pgt
3651: WHERE pgt.key = l_old_key
3652: AND nvl(poll.cancel_flag,'N') = 'N'
3653: AND nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 5007: po_line_locations poll,

5003: AND poad.latest_external_flag ='Y')
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'

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 5041: UPDATE po_line_locations poll

5037: PO_DEBUG.debug_var(d_module,l_progress,'Updated distributions-Line Count',l_line_id_tbl.count);
5038: END IF;
5039:
5040: -- Reverting back the Lines Quantity and amount
5041: UPDATE po_line_locations poll
5042: SET (price_override,
5043: quantity,
5044: amount,
5045: need_by_date,

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 5078: FROM po_line_locations POLL

5074: SUM(NVL(poll.quantity,0)
5075: - NVL(poll.quantity_cancelled, 0))
5076:
5077:
5078: FROM po_line_locations POLL
5079: WHERE poll.po_line_id = pol.po_line_id)
5080: WHERE po_line_id IN (SELECT *
5081: FROM TABLE (CAST (l_line_id_tbl AS po_tbl_number)));
5082:

Line 5092: FROM po_line_locations poll

5088: FROM po_lines_archive_all
5089: WHERE po_line_id = pol.po_line_id
5090: AND latest_external_flag='Y')
5091: WHERE po_line_id IN (SELECT po_line_id
5092: FROM po_line_locations poll
5093: WHERE poll.payment_type IS NULL
5094: AND line_location_id IN
5095: (SELECT *
5096: FROM TABLE (CAST (l_line_loc_id_tbl AS po_tbl_number)))

Line 5105: FROM po_line_locations

5101: -- Updating Price for Complex PO Line with Milestone pay items
5102: UPDATE po_lines pol
5103: SET pol.unit_price =
5104: (SELECT SUM(price_override)
5105: FROM po_line_locations
5106: WHERE po_line_id = pol.po_line_id)
5107: WHERE pol.order_type_lookup_code IN ('QUANTITY', 'AMOUNT')
5108: AND po_line_id IN (SELECT po_line_id
5109: FROM po_line_locations poll

Line 5109: FROM po_line_locations poll

5105: FROM po_line_locations
5106: WHERE po_line_id = pol.po_line_id)
5107: WHERE pol.order_type_lookup_code IN ('QUANTITY', 'AMOUNT')
5108: AND po_line_id IN (SELECT po_line_id
5109: FROM po_line_locations poll
5110: WHERE poll.payment_type IS NOT NULL
5111: AND line_location_id IN
5112: (SELECT *
5113: FROM TABLE (CAST (l_line_loc_id_tbl AS po_tbl_number)))

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 5193: po_line_locations poll,

5189: 'I',
5190: gt.num1,
5191: gt.char3
5192: FROM
5193: po_line_locations poll,
5194: po_lines pol,
5195: po_session_gt gt
5196: WHERE
5197: gt.key=p_key

Line 5359: po_line_locations poll,

5355: gt.num1,
5356: gt.char3
5357: FROM
5358: po_distributions_all pod,
5359: po_line_locations poll,
5360: po_lines pol ,
5361: po_session_gt gt
5362: WHERE
5363: gt.key=p_low_level_key

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 5486: po_line_locations poll,

5482: gt.num1,
5483: gt.char3
5484: FROM
5485: po_distributions_all pod,
5486: po_line_locations poll,
5487: po_lines pol ,
5488: po_session_gt gt
5489: WHERE
5490: gt.key=p_low_level_key

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)

Line 5744: -- valid line_location_id in po_line_locations

5740:
5741: -- Function:1.Validates the entity id against the entity level :The entity id
5742: -- should be a valid id at that level.
5743: -- - If the entity level is SHIPMENT, then the entity_id should a
5744: -- valid line_location_id in po_line_locations
5745: -- - If the entity level is LINE, then the entity_id should a
5746: -- valid po_line_id in po_lines
5747: -- - If the entity level is HEADER, then the entity_id should a
5748: -- valid po_header_id/po_release_id in po_headers/po_releases

Line 5871: -- then the entity_id should a valid line_location_id in po_line_locations

5867: p_sequence := P_SEQUENCE + SQL%ROWCOUNT;
5868: l_progress := '002';
5869:
5870: -- Validate : If the entity level is SHIPMENT,
5871: -- then the entity_id should a valid line_location_id in po_line_locations
5872: INSERT INTO PO_ONLINE_REPORT_TEXT(
5873: ONLINE_REPORT_ID,
5874: LAST_UPDATE_LOGIN,
5875: LAST_UPDATED_BY,

Line 5908: FROM po_line_locations poll

5904: po_session_gt gt
5905: WHERE gt.key=p_key
5906: AND gt.char3 =po_document_cancel_pvt.c_entity_level_SHIPMENT
5907: AND NOT EXISTS (SELECT '1'
5908: FROM po_line_locations poll
5909: WHERE poll.line_location_id = gt.num1
5910: ));
5911:
5912:

Line 6121: FROM po_line_locations poll,

6117: AND gt.num1=pol.po_line_id
6118: AND gt.char3=PO_Document_Cancel_PVT.c_entity_level_LINE
6119: UNION ALL
6120: SELECT poll.po_header_id
6121: FROM po_line_locations poll,
6122: po_session_gt gt
6123: WHERE gt.KEY=p_key
6124: AND gt.num1=poll.line_location_id
6125: AND gt.char3=PO_Document_Cancel_PVT.c_entity_level_SHIPMENT

Line 6202: -- valid line_location_id in po_line_locations

6198:
6199: -- Function:1.Validated the entity id against the entity level :The entity id
6200: -- should be a valid id at that level.
6201: -- - If the entity level is SHIPMENT, then the entity_id should a
6202: -- valid line_location_id in po_line_locations
6203: -- - If the entity level is LINE, then the entity_id should a valid
6204: -- po_line_id in po_lines
6205: -- - If the entity level is HEADER, then the entity_id should a
6206: -- valid po_header_id/po_release_id in po_headers/po_releases