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_DOCUMENT_CANCEL_PVT dependencies on PO_LINE_LOCATIONS

Line 63: FROM po_line_locations

59: l_order_line_status NUMBER;
60:
61: CURSOR l_drop_ship_csr IS
62: SELECT line_location_id
63: FROM po_line_locations
64: WHERE NVL(drop_ship_flag, 'N') = 'Y'
65: AND ((p_entity_level = c_entity_level_HEADER
66: AND p_document_type <> c_doc_type_RELEASE
67: AND po_header_id = p_entity_id)

Line 225: FROM po_line_locations

221: SELECT 1
222: INTO l_partial_rcv_bld
223: FROM DUAL
224: WHERE EXISTS (SELECT 1
225: FROM po_line_locations
226: WHERE ( (p_document_type <>c_doc_type_RELEASE
227: AND po_header_id = p_entity_id)
228: OR(p_document_type = c_doc_type_RELEASE
229: AND po_release_id = p_entity_id)

Line 243: FROM po_line_locations

239: SELECT 1
240: INTO l_partial_rcv_bld
241: FROM DUAL
242: WHERE EXISTS (SELECT 1
243: FROM po_line_locations
244: WHERE po_line_id = p_entity_id
245: AND NVL(cancel_flag, 'N') <> 'Y'
246: AND NVL(closed_code, 'OPEN') <> 'FINALLY CLOSED'
247: AND(quantity_received > 0

Line 257: FROM po_line_locations

253: SELECT 1
254: INTO l_partial_rcv_bld
255: FROM DUAL
256: WHERE EXISTS(SELECT 1
257: FROM po_line_locations
258: WHERE line_location_id = p_entity_id
259: AND NVL(cancel_flag, 'N') <> 'Y'
260: AND NVL(closed_code, 'OPEN') <> 'FINALLY CLOSED'
261: AND ( quantity_received > 0 OR quantity_billed > 0));

Line 565: UPDATE po_line_locations POLL

561: END IF;
562:
563: l_progress := '001' ;
564:
565: UPDATE po_line_locations POLL
566: SET (POLL.quantity_billed, POLL.quantity_received) =
567: (SELECT
568: SUM( NVL(RELS.quantity_billed, 0) ),
569: SUM( NVL(RELS.quantity_received, 0) )

Line 571: PO_LINE_LOCATIONS RELS

567: (SELECT
568: SUM( NVL(RELS.quantity_billed, 0) ),
569: SUM( NVL(RELS.quantity_received, 0) )
570: FROM
571: PO_LINE_LOCATIONS RELS
572: WHERE
573: RELS.source_shipment_id = POLL.line_location_id )
574: WHERE POLL.shipment_type = 'PLANNED'
575: AND POLL.line_location_id IN

Line 582: FROM po_line_locations,

578: WHERE char3 = c_entity_level_SHIPMENT
579: AND char2 = c_doc_subtype_PLANNED
580: UNION
581: SELECT line_location_id
582: FROM po_line_locations,
583: po_session_gt
584: WHERE num1 = po_line_id
585: AND char3 = c_entity_level_LINE
586: AND char2 = c_doc_subtype_PLANNED

Line 591: FROM po_line_locations,

587: AND NVL(cancel_flag, 'N') = 'N'
588: AND NVL(closed_code, 'OPEN') <> 'FINALLY CLOSED'
589: UNION
590: SELECT line_location_id
591: FROM po_line_locations,
592: po_session_gt
593: WHERE num1 = po_header_id
594: AND char3 = c_entity_level_HEADER
595: AND char2 = c_doc_subtype_PLANNED

Line 601: PO_DEBUG.debug_var(d_module, l_progress, 'Rows Updated the PO line locations table', SQL%ROWCOUNT);

597: AND NVL(closed_code, 'OPEN') <> 'FINALLY CLOSED'
598: );
599:
600: IF g_debug_stmt THEN
601: PO_DEBUG.debug_var(d_module, l_progress, 'Rows Updated the PO line locations table', SQL%ROWCOUNT);
602: END IF;
603:
604: l_progress := '002' ;
605:

Line 620: FROM po_line_locations,

616: AND char2 = c_doc_subtype_PLANNED
617: AND char5 = 'Y'
618: UNION
619: SELECT line_location_id
620: FROM po_line_locations,
621: po_session_gt
622: WHERE num1 = po_line_id
623: AND shipment_type = 'PLANNED'
624: AND char3 = c_entity_level_LINE

Line 631: FROM po_line_locations,

627: AND char5 = 'Y'
628: AND NVL(closed_code, 'OPEN') <> 'FINALLY CLOSED'
629: UNION
630: SELECT line_location_id
631: FROM po_line_locations,
632: po_session_gt
633: WHERE num1 = po_header_id
634: AND shipment_type = 'PLANNED'
635: AND char3 = c_entity_level_HEADER

Line 769: FROM po_line_locations

765: pod.last_updated_by = p_user_id ,
766: pod.last_update_login = p_login_id
767: WHERE pod.line_location_id IN
768: ( SELECT line_location_id
769: FROM po_line_locations
770: WHERE line_location_id = p_entity_id
771: AND p_entity_level = c_entity_level_SHIPMENT
772: UNION ALL
773: SELECT line_location_id

Line 774: FROM po_line_locations

770: WHERE line_location_id = p_entity_id
771: AND p_entity_level = c_entity_level_SHIPMENT
772: UNION ALL
773: SELECT line_location_id
774: FROM po_line_locations
775: WHERE po_line_id = p_entity_id
776: AND p_entity_level = c_entity_level_LINE
777: UNION ALL
778: SELECT line_location_id

Line 779: FROM po_line_locations

775: WHERE po_line_id = p_entity_id
776: AND p_entity_level = c_entity_level_LINE
777: UNION ALL
778: SELECT line_location_id
779: FROM po_line_locations
780: WHERE po_header_id = p_entity_id
781: AND p_document_type <> c_doc_type_RELEASE
782: AND p_entity_level = c_entity_level_HEADER
783: UNION ALL

Line 785: FROM po_line_locations

781: AND p_document_type <> c_doc_type_RELEASE
782: AND p_entity_level = c_entity_level_HEADER
783: UNION ALL
784: SELECT line_location_id
785: FROM po_line_locations
786: WHERE po_release_id = p_entity_id
787: AND p_document_type = c_doc_type_RELEASE
788: AND p_entity_level = c_entity_level_HEADER);
789:

Line 815: FROM po_line_locations

811: pod.last_updated_by = p_user_id,
812: pod.last_update_login = p_login_id
813: WHERE pod.line_location_id IN
814: ( SELECT line_location_id
815: FROM po_line_locations
816: WHERE line_location_id = p_entity_id
817: AND p_entity_level = c_entity_level_SHIPMENT
818: UNION ALL
819: SELECT line_location_id

Line 820: FROM po_line_locations

816: WHERE line_location_id = p_entity_id
817: AND p_entity_level = c_entity_level_SHIPMENT
818: UNION ALL
819: SELECT line_location_id
820: FROM po_line_locations
821: WHERE po_line_id = p_entity_id
822: AND p_entity_level = c_entity_level_LINE
823: UNION ALL
824: SELECT line_location_id

Line 825: FROM po_line_locations

821: WHERE po_line_id = p_entity_id
822: AND p_entity_level = c_entity_level_LINE
823: UNION ALL
824: SELECT line_location_id
825: FROM po_line_locations
826: WHERE po_header_id = p_entity_id
827: AND p_document_type <> c_doc_type_RELEASE
828: AND p_entity_level = c_entity_level_HEADER
829: UNION ALL

Line 831: FROM po_line_locations

827: AND p_document_type <> c_doc_type_RELEASE
828: AND p_entity_level = c_entity_level_HEADER
829: UNION ALL
830: SELECT line_location_id
831: FROM po_line_locations
832: WHERE po_release_id = p_entity_id
833: AND p_document_type = c_doc_type_RELEASE
834: AND p_entity_level = c_entity_level_HEADER);
835:

Line 964: UPDATE po_line_locations POLL

960: IF p_fc_level = c_before_FC THEN
961:
962: l_progress := '001' ;
963:
964: UPDATE po_line_locations POLL
965: SET POLL.cancel_flag = 'I' ,
966: --Bug 16575765: CANCEL_DATE is always stamped(SHIPMENT) as sysdate.
967: --POLL.cancel_date = p_action_date ,
968: POLL.cancel_date = SYSDATE ,

Line 990: FROM po_line_locations

986: WHERE NVL(poll.cancel_flag, 'N') = 'N'
987: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
988: AND POLL.line_location_id IN
989: ( SELECT line_location_id
990: FROM po_line_locations
991: WHERE line_location_id = p_entity_id
992: AND p_entity_level = c_entity_level_SHIPMENT
993: UNION ALL
994: SELECT line_location_id

Line 995: FROM po_line_locations

991: WHERE line_location_id = p_entity_id
992: AND p_entity_level = c_entity_level_SHIPMENT
993: UNION ALL
994: SELECT line_location_id
995: FROM po_line_locations
996: WHERE po_line_id = p_entity_id
997: AND p_entity_level = c_entity_level_LINE
998: UNION ALL
999: SELECT line_location_id

Line 1000: FROM po_line_locations

996: WHERE po_line_id = p_entity_id
997: AND p_entity_level = c_entity_level_LINE
998: UNION ALL
999: SELECT line_location_id
1000: FROM po_line_locations
1001: WHERE po_header_id = p_entity_id
1002: AND p_document_type <> c_doc_type_RELEASE
1003: AND p_entity_level = c_entity_level_HEADER
1004: UNION ALL

Line 1006: FROM po_line_locations

1002: AND p_document_type <> c_doc_type_RELEASE
1003: AND p_entity_level = c_entity_level_HEADER
1004: UNION ALL
1005: SELECT line_location_id
1006: FROM po_line_locations
1007: WHERE po_release_id = p_entity_id
1008: AND p_document_type = c_doc_type_RELEASE
1009: AND p_entity_level = c_entity_level_HEADER);
1010:

Line 1016: UPDATE po_line_locations POLL

1012: ELSE
1013:
1014: l_progress := '002' ;
1015:
1016: UPDATE po_line_locations POLL
1017: SET POLL.cancel_flag = 'Y'
1018: WHERE NVL(poll.cancel_flag, 'N') = 'I'
1019: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1020: AND POLL.line_location_id IN

Line 1022: FROM po_line_locations

1018: WHERE NVL(poll.cancel_flag, 'N') = 'I'
1019: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1020: AND POLL.line_location_id IN
1021: ( SELECT line_location_id
1022: FROM po_line_locations
1023: WHERE line_location_id = p_entity_id
1024: AND p_entity_level = c_entity_level_SHIPMENT
1025: UNION ALL
1026: SELECT line_location_id

Line 1027: FROM po_line_locations

1023: WHERE line_location_id = p_entity_id
1024: AND p_entity_level = c_entity_level_SHIPMENT
1025: UNION ALL
1026: SELECT line_location_id
1027: FROM po_line_locations
1028: WHERE po_line_id = p_entity_id
1029: AND p_entity_level = c_entity_level_LINE
1030: UNION ALL
1031: SELECT line_location_id

Line 1032: FROM po_line_locations

1028: WHERE po_line_id = p_entity_id
1029: AND p_entity_level = c_entity_level_LINE
1030: UNION ALL
1031: SELECT line_location_id
1032: FROM po_line_locations
1033: WHERE po_header_id = p_entity_id
1034: AND p_document_type <> c_doc_type_RELEASE
1035: AND p_entity_level = c_entity_level_HEADER
1036: UNION ALL

Line 1038: FROM po_line_locations

1034: AND p_document_type <> c_doc_type_RELEASE
1035: AND p_entity_level = c_entity_level_HEADER
1036: UNION ALL
1037: SELECT line_location_id
1038: FROM po_line_locations
1039: WHERE po_release_id = p_entity_id
1040: AND p_document_type = c_doc_type_RELEASE
1041: AND p_entity_level = c_entity_level_HEADER);
1042:

Line 1132: FROM po_line_locations POLL

1128: UPDATE po_lines pol
1129: SET pol.quantity =(SELECT SUM(
1130: NVL(poll.quantity,0)
1131: - NVL(poll.quantity_cancelled, 0))
1132: FROM po_line_locations POLL
1133: WHERE poll.po_line_id = pol.po_line_id
1134: AND poll.shipment_type IN ('STANDARD','PLANNED'))
1135:
1136: WHERE pol.po_line_id=(SELECT po_line_id

Line 1137: FROM po_line_locations

1133: WHERE poll.po_line_id = pol.po_line_id
1134: AND poll.shipment_type IN ('STANDARD','PLANNED'))
1135:
1136: WHERE pol.po_line_id=(SELECT po_line_id
1137: FROM po_line_locations
1138: WHERE line_location_id = p_ship_id)
1139: AND pol.order_type_lookup_code IN ('QUANTITY','AMOUNT')
1140: AND NOT EXISTS (SELECT
1141: 'PO Line has Qty Milestone Pay Items'

Line 1142: FROM po_line_locations poll2

1138: WHERE line_location_id = p_ship_id)
1139: AND pol.order_type_lookup_code IN ('QUANTITY','AMOUNT')
1140: AND NOT EXISTS (SELECT
1141: 'PO Line has Qty Milestone Pay Items'
1142: FROM po_line_locations poll2
1143: WHERE poll2.po_line_id=pol.po_line_id
1144: AND poll2.payment_type IS NOT NULL);
1145:
1146: IF g_debug_stmt THEN

Line 1160: FROM po_line_locations POLL

1156:
1157: UPDATE po_lines pol
1158: SET pol.unit_price =
1159: (SELECT SUM(poll.price_override)
1160: FROM po_line_locations POLL
1161: WHERE poll.po_line_id = pol.po_line_id
1162: AND poll.shipment_type = 'STANDARD'
1163: AND nvl(poll.cancel_flag, 'N') = 'N'
1164: AND nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED')

Line 1167: FROM po_line_locations

1163: AND nvl(poll.cancel_flag, 'N') = 'N'
1164: AND nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED')
1165:
1166: WHERE pol.po_line_id=(SELECT po_line_id
1167: FROM po_line_locations
1168: WHERE line_location_id= p_ship_id)
1169: AND pol.order_type_lookup_code IN ('QUANTITY', 'AMOUNT')
1170: AND EXISTS
1171: (SELECT 'PO Line has open Qty Milestone Pay Items'

Line 1172: FROM po_line_locations poll2

1168: WHERE line_location_id= p_ship_id)
1169: AND pol.order_type_lookup_code IN ('QUANTITY', 'AMOUNT')
1170: AND EXISTS
1171: (SELECT 'PO Line has open Qty Milestone Pay Items'
1172: FROM po_line_locations poll2
1173: WHERE poll2.po_line_id = pol.po_line_id
1174: AND poll2.payment_type IS NOT NULL
1175: AND nvl(poll2.cancel_flag, 'N') = 'N'
1176: AND nvl(poll2.closed_code, 'OPEN') <> 'FINALLY CLOSED');

Line 1202: FROM po_line_locations POLL

1198: * POLL.price_override),
1199: -- Fixed Price or Rate Line Locations
1200: (NVL(poll.amount, 0) - NVL(poll.amount_cancelled,0))
1201: ))
1202: FROM po_line_locations POLL
1203: WHERE poll.po_line_id = pol.po_line_id
1204: AND poll.shipment_type IN ('STANDARD','PLANNED'))
1205:
1206: WHERE pol.po_line_id =(SELECT po_line_id

Line 1207: FROM po_line_locations

1203: WHERE poll.po_line_id = pol.po_line_id
1204: AND poll.shipment_type IN ('STANDARD','PLANNED'))
1205:
1206: WHERE pol.po_line_id =(SELECT po_line_id
1207: FROM po_line_locations
1208: WHERE line_location_id= p_ship_id)
1209: AND pol.order_type_lookup_code in ('FIXED PRICE', 'RATE');
1210:
1211:

Line 1357: FROM po_line_locations POLL

1353: DECODE(pol.quantity,
1354: NULL,
1355: pol.quantity,
1356: (SELECT SUM(NVL(poll.quantity,0) -NVL(poll.quantity_cancelled,0))
1357: FROM po_line_locations POLL
1358: WHERE poll.po_line_id = pol.po_line_id
1359: AND poll.shipment_type IN('STANDARD','PLANNED'))
1360: ),
1361: pol.amount =

Line 1372: FROM po_line_locations POLL

1368: * POLL.price_override),
1369: (NVL(poll.amount, 0) -NVL(poll.amount_cancelled,0))
1370: )
1371: )
1372: FROM po_line_locations POLL
1373: WHERE poll.po_line_id = pol.po_line_id
1374: AND poll.shipment_type IN ('STANDARD','PLANNED')) )
1375: WHERE nvl(pol.cancel_flag,'N') = 'N'
1376: AND nvl(pol.closed_code,'OPEN') <> 'FINALLY CLOSED'

Line 2648: po_line_locations poll ,

2644:
2645: CURSOR l_before_fc_csr IS
2646: SELECT DISTINCT(prd.requisition_line_id)
2647: FROM po_req_distributions_all prd,
2648: po_line_locations poll ,
2649: po_distributions_all pod
2650: WHERE pod.line_location_id = poll.line_location_id
2651: AND pod.req_distribution_id = prd.distribution_id
2652: AND NVL(poll.cancel_flag, 'N') = 'I'

Line 2674: po_line_locations poll

2670:
2671: CURSOR l_after_fc_csr IS
2672: SELECT DISTINCT(prl.requisition_line_id)
2673: FROM po_requisition_lines_all prl,
2674: po_line_locations poll
2675: WHERE prl.line_location_id= (-1 * poll.line_location_id)
2676: AND NVL(poll.cancel_flag, 'N') = 'Y'
2677: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2678: AND poll.shipment_type IN(

Line 2853: po_line_locations POLL ,

2849: PORL.UNIT_MEAS_LOOKUP_CODE,
2850: PORL.ITEM_ID)
2851: INTO x_uom_conv
2852: FROM PO_REQUISITION_LINES_ALL PORL,
2853: po_line_locations POLL ,
2854: po_lines POL
2855: WHERE PORL.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
2856: AND POLL.PO_LINE_ID = POL.PO_LINE_ID
2857: AND PORL.REQUISITION_LINE_ID = p_req_line_id ;

Line 2866: po_line_locations POLL ,

2862: PORL.UNIT_MEAS_LOOKUP_CODE,
2863: PORL.ITEM_ID)
2864: INTO x_uom_conv
2865: FROM PO_REQUISITION_LINES_ALL PORL,
2866: po_line_locations POLL ,
2867: po_lines POL
2868: WHERE (-1)*PORL.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
2869: AND POLL.PO_LINE_ID = POL.PO_LINE_ID
2870: and porl.requisition_line_id = p_req_line_id ;

Line 2961: po_line_locations POLL

2957: )
2958: INTO x_qty_cancelled
2959: FROM PO_DISTRIBUTIONS_ALL POd ,
2960: po_req_distributions_all pord,
2961: po_line_locations POLL
2962: WHERE pord.requisition_line_id = p_req_line_id
2963: AND pord.distribution_id = pod.req_distribution_id
2964: AND POLL.line_location_id = POD.line_location_id
2965: AND POLL.shipment_type IN(

Line 3122: FROM po_line_locations POLL,

3118: PORD.req_line_quantity,
3119: SUM(l_uom_conv * (greatest(NVL(POD.quantity_delivered, 0),
3120: NVL(POD.quantity_billed, 0)) )) )
3121:
3122: FROM po_line_locations POLL,
3123: PO_DISTRIBUTIONS_ALL POD
3124: WHERE POD.req_distribution_id = PORD.distribution_id
3125: AND POLL.line_location_id = POD.line_location_id
3126: AND POLL.shipment_type IN ('STANDARD',

Line 3183: FROM po_line_locations POLL,

3179: Greatest(NVL(POD.quantity_delivered, 0),
3180: NVL(POD.quantity_billed, 0))
3181: )
3182: )
3183: FROM po_line_locations POLL,
3184: PO_DISTRIBUTIONS_ALL POD
3185: WHERE POD.req_distribution_id = PORD.distribution_id
3186: AND POLL.line_location_id = POD.line_location_id
3187: AND POLL.shipment_type IN ('STANDARD' ,

Line 3243: FROM po_line_locations POLL,

3239: l_qty_cancelled),
3240: SYSDATE ,
3241: p_user_id ,
3242: p_login_id
3243: FROM po_line_locations POLL,
3244: po_lines POL
3245: WHERE PORL.line_location_id = POLL.line_location_id
3246: AND POLL.po_line_id = POL.po_line_id)
3247: WHERE PORL.requisition_line_id = (

Line 3779: po_line_locations POLL ,

3775: PORL.CATALOG_TYPE ,
3776: PORL.CATALOG_SOURCE
3777: FROM
3778: PO_REQUISITION_LINES_ALL PORL,
3779: po_line_locations POLL ,
3780: po_lines POL
3781: WHERE
3782: PORL.REQUISITION_LINE_ID = p_old_line_id
3783: AND PORL.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID

Line 4046: PO_LINE_LOCATIONS PLL ,

4042: PO_REQ_DISTRIBUTIONS_ALL PORD ,
4043: PO_REQUISITION_LINES_ALL PORL_OLD,
4044: PO_REQUISITION_LINES_ALL PORL_NEW,
4045: PO_DISTRIBUTIONS_ALL POD ,
4046: PO_LINE_LOCATIONS PLL ,
4047: po_headers BLANKET
4048: WHERE
4049: PORL_NEW.requisition_line_id = p_req_line_id
4050: AND PORL_OLD.requisition_line_id = (-1) * PORL_NEW.parent_req_line_id

Line 4357: po_line_locations PLL ,

4353: NULL)),
4354: 'N')
4355: FROM PO_REQUISITION_LINES_ALL PORL,
4356: PO_DISTRIBUTIONS_ALL POD ,
4357: po_line_locations PLL ,
4358: po_headers BLANKET
4359: WHERE PORL.requisition_line_id = PORD.requisition_line_id
4360: AND POD.req_distribution_id = PORD.distribution_id
4361: AND POD.line_location_id = PLL.line_location_id

Line 4452: FROM po_line_locations POLL,

4448: l_quantity),
4449: SYSDATE ,
4450: p_user_id ,
4451: p_login_id
4452: FROM po_line_locations POLL,
4453: po_lines POL
4454: WHERE PORL.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
4455: AND POLL.PO_LINE_ID = POL.PO_LINE_ID
4456: )

Line 5199: UPDATE po_line_locations

5195: ELSE
5196: -- If the document Line/Shipment is Canceled then approve the corresponding shipemnts
5197: l_progress := '002' ;
5198:
5199: UPDATE po_line_locations
5200: SET approved_flag = 'Y',
5201: approved_date = SYSDATE
5202: WHERE ( (line_location_id = p_entity_id
5203: AND p_entity_level = c_entity_level_SHIPMENT)

Line 5208: PO_DEBUG.debug_var(d_module, l_progress, 'Rows Updated the PO line locations table', SQL%ROWCOUNT);

5204: OR(po_line_id = p_entity_id
5205: AND p_entity_level = c_entity_level_LINE));
5206:
5207: IF g_debug_stmt THEN
5208: PO_DEBUG.debug_var(d_module, l_progress, 'Rows Updated the PO line locations table', SQL%ROWCOUNT);
5209: END IF;
5210:
5211: END IF;
5212:

Line 5381: FROM po_line_locations

5377: IF p_entity_level <> c_entity_level_HEADER THEN
5378:
5379: SELECT COUNT(1)
5380: INTO l_count
5381: FROM po_line_locations
5382: WHERE NVL(approved_flag, 'N') = 'R'
5383: AND ( (line_location_id = p_entity_id
5384: AND p_entity_level = c_entity_level_LINE
5385: AND p_document_type <> c_doc_type_PA)

Line 5615: -- Closure Points and Tolerance Levels are set in po_line_locations (for

5611: -- Update the Status of Shipments, based on the Receiving and Invoicing
5612: -- Closure Point Quantities, and Rollup if necessary
5613: -- For example, if all of a shipment has been received, then the shipment
5614: -- is closed for receiving
5615: -- Closure Points and Tolerance Levels are set in po_line_locations (for
5616: -- tolerances) and in po_system_parameters (for closed codes) respectively.
5617: -- This method wraps PO_DOCUMENT_ACTION_PVT.auto_close_update_state. .
5618: --
5619: --

Line 6557: po_line_locations POLL

6553: SELECT COUNT(*)
6554: INTO l_cto_order
6555: FROM po_requisition_headers_all PRH,
6556: po_requisition_lines_all PRL,
6557: po_line_locations POLL
6558: WHERE PRH.interface_source_code = 'CTO'
6559: AND PRH.requisition_header_id = PRL.requisition_header_id
6560: AND PRL.line_location_id = POLL.line_location_id
6561: AND ( ((p_doc_type = 'PO') AND (POLL.po_header_id = p_doc_id)) OR

Line 6766: FROM po_line_locations

6762: p_doc_header_id NUMBER,
6763: p_document_type VARCHAR2)
6764: IS
6765: SELECT line_location_id
6766: FROM po_line_locations
6767: WHERE line_location_id = p_line_location_id
6768: AND p_line_location_id IS NOT NULL
6769: UNION ALL
6770: SELECT line_location_id

Line 6771: FROM po_line_locations

6767: WHERE line_location_id = p_line_location_id
6768: AND p_line_location_id IS NOT NULL
6769: UNION ALL
6770: SELECT line_location_id
6771: FROM po_line_locations
6772: WHERE po_line_id = p_line_id
6773: AND p_line_location_id IS NULL
6774: AND p_line_id IS NOT NULL
6775:

Line 6778: FROM po_line_locations

6774: AND p_line_id IS NOT NULL
6775:
6776: UNION ALL
6777: SELECT line_location_id
6778: FROM po_line_locations
6779: WHERE po_header_id = p_doc_header_id
6780: AND p_line_location_id IS NULL
6781: AND p_line_id IS NULL
6782: AND p_doc_header_id IS NOT NULL

Line 6787: FROM po_line_locations

6783: AND p_document_type <> c_doc_type_RELEASE
6784:
6785: UNION ALL
6786: SELECT line_location_id
6787: FROM po_line_locations
6788: WHERE po_release_id = p_doc_header_id
6789: AND p_line_location_id IS NULL
6790: AND p_line_id IS NULL
6791: AND p_doc_header_id IS NOT NULL

Line 6884: UPDATE po_line_locations POLL

6880: END IF;
6881:
6882: l_progress := '004' ;
6883:
6884: UPDATE po_line_locations POLL
6885: SET POLL.last_update_date = p_action_date,
6886: POLL.last_updated_by = l_user_id,
6887: POLL.last_update_login = l_login_id,
6888: POLL.quantity_cancelled = (SELECT SUM(NVL(POD.quantity_cancelled,0))

Line 6911: FROM po_line_locations POLL

6907: DECODE(pol.quantity,
6908: NULL,
6909: pol.quantity,
6910: (SELECT SUM(NVL(poll.quantity,0) -NVL(poll.quantity_cancelled,0))
6911: FROM po_line_locations POLL
6912: WHERE poll.po_line_id = pol.po_line_id
6913: AND poll.shipment_type IN('STANDARD','PLANNED'))
6914: ),
6915: pol.amount =

Line 6926: FROM po_line_locations POLL

6922: * POLL.price_override),
6923: (NVL(poll.amount, 0) -NVL(poll.amount_cancelled,0))
6924: )
6925: )
6926: FROM po_line_locations POLL
6927: WHERE poll.po_line_id = pol.po_line_id
6928: AND poll.shipment_type IN ('STANDARD','PLANNED')) )
6929:
6930: WHERE pol.po_line_id IN(SELECT DISTINCT po_line_id

Line 6931: FROM po_line_locations

6927: WHERE poll.po_line_id = pol.po_line_id
6928: AND poll.shipment_type IN ('STANDARD','PLANNED')) )
6929:
6930: WHERE pol.po_line_id IN(SELECT DISTINCT po_line_id
6931: FROM po_line_locations
6932: WHERE line_location_id=l_line_loc_tbl(i)
6933: AND shipment_type IN ('STANDARD','PLANNED'));
6934:
6935: IF g_debug_stmt THEN