[Home] [Help]
68: , Nvl(pll.enforce_ship_to_location_code,'NONE') enforce_ship_to_location_code
69: , 0 rcv_transaction_id -- only need it for std_deliver
70: , pl.item_revision --only needed for std_deliver
71: FROM
72: po_line_locations pll,
73: po_lines pl,
74: -- Bug 3444226 The Join with po_headers is unnecessary
75: -- po_headers ph,
76: rcv_shipment_lines rsl,
133: , v_organization_id NUMBER)
134: IS
135: SELECT COUNT(*)
136: FROM
137: po_line_locations pll,
138: po_lines pl,
139: -- Bug 3444226 The Join with po_headers is unnecessary
140: -- po_headers ph,
141: rcv_shipment_lines rsl,
211: , Nvl(pll.enforce_ship_to_location_code,'NONE') enforce_ship_to_location_code
212: , 0 rcv_transaction_id -- only need it for std_deliver
213: , pl.item_revision --only needed for std_deliver
214: FROM
215: po_line_locations pll,
216: po_lines pl,
217: -- Bug 3444226 The Join with po_headers is unnecessary
218: -- po_headers ph,
219: rcv_shipment_lines rsl,
281: , v_organization_id NUMBER)
282: IS
283: SELECT COUNT(*)
284: FROM
285: po_line_locations pll,
286: po_lines pl,
287: -- Bug 3444226 The Join with po_headers is unnecessary
288: -- po_headers ph,
289: rcv_shipment_lines rsl,
363: , Nvl(pll.enforce_ship_to_location_code,'NONE') enforce_ship_to_location_code
364: , 0 rcv_transaction_id -- only need it for std_deliver
365: , pl.item_revision --only needed for std_deliver
366: FROM
367: po_line_locations pll,
368: po_lines pl,
369: -- Bug 3444226 The Join with po_headers is unnecessary
370: -- po_headers ph,
371: rcv_shipment_lines rsl,
428: , v_organization_id NUMBER)
429: IS
430: SELECT COUNT(*)
431: FROM
432: po_line_locations pll,
433: po_lines pl,
434: -- Bug 3444226 The Join with po_headers is unnecessary
435: -- po_headers ph,
436: rcv_shipment_lines rsl,
506: , Nvl(pll.enforce_ship_to_location_code,'NONE') enforce_ship_to_location_code
507: , 0 rcv_transaction_id -- only need it for std_deliver
508: , pl.item_revision --only needed for std_deliver
509: FROM
510: po_line_locations pll,
511: po_lines pl,
512: -- Bug 3444226 The Join with po_headers is unnecessary
513: -- po_headers ph,
514: rcv_shipment_lines rsl,
576: , v_organization_id NUMBER)
577: IS
578: SELECT COUNT(*)
579: FROM
580: po_line_locations pll,
581: po_lines pl,
582: -- Bug 3444226 The Join with po_headers is unnecessary
583: -- po_headers ph,
584: rcv_shipment_lines rsl,
657: , pll.ship_to_location_id
658: , nvl(pll.enforce_ship_to_location_code,'NONE') enforce_ship_to_location_code
659: , 0 rcv_transaction_id -- only need it for std_deliver
660: , pl.item_revision --only needed for std_deliver
661: from po_line_locations_all pll,
662: po_lines_all pl
663: -- For Bug 7440217
664: , mtl_parameters mp,
665: rcv_parameters rp
730: , v_organization_id NUMBER)
731:
732: IS
733: SELECT COUNT(*)
734: from po_line_locations_all pll,
735: po_lines_all pl
736: -- For Bug 7440217
737: , mtl_parameters mp,
738: rcv_parameters rp
811: ,nvl(pll.enforce_ship_to_location_code,'NONE') enforce_ship_to_location_code
812: ,0 rcv_transaction_id -- only need it for std_deliver
813: ,pl.item_revision --only needed for std_deliver
814: from po_distributions pod,
815: po_line_locations pll,
816: po_lines pl,
817: po_headers ph
818: where ph.po_header_id = header_id
819: and pod.po_header_id = header_id
864: , v_task_id NUMBER
865: , v_organization_id NUMBER) is
866: select count(*)
867: from po_distributions pod,
868: po_line_locations pll,
869: po_lines pl
870: where pll.po_header_id = header_id
871: AND pod.po_line_id = Nvl(v_po_line_id, pod.po_line_id)
872: AND pod.line_location_id = Nvl(v_po_line_location_id, pod.line_location_id)
937: ,nvl(pll.enforce_ship_to_location_code,'NONE') enforce_ship_to_location_code
938: ,rs.rcv_transaction_id
939: ,rs.item_revision
940: from po_distributions pod,
941: po_line_locations pll,
942: po_lines pl,
943: -- Bug 3444226 The Join with po_headers is unnecessary
944: -- po_headers ph,
945: rcv_supply rs,
1037: ,v_parent_txn_id_to_match NUMBER
1038: , v_organization_id NUMBER) IS
1039: SELECT count(*)
1040: FROM po_distributions pod,
1041: po_line_locations pll,
1042: po_lines pl,
1043: -- Bug 3444226 The Join with po_headers is unnecessary
1044: -- po_headers ph,
1045: rcv_supply rs,
1148: ,nvl(pll.enforce_ship_to_location_code,'NONE') enforce_ship_to_location_code
1149: ,rs.rcv_transaction_id
1150: ,rs.item_revision
1151: from po_distributions pod,
1152: po_line_locations pll,
1153: po_lines pl,
1154: rcv_supply rs,
1155: rcv_shipment_headers rsh,
1156: rcv_transactions rt
1235: ,v_parent_txn_id_to_match NUMBER
1236: , v_organization_id NUMBER) IS
1237: SELECT count(*)
1238: FROM po_distributions pod,
1239: po_line_locations pll,
1240: po_lines pl,
1241: rcv_supply rs,
1242: rcv_shipment_headers rsh,
1243: rcv_transactions rt
1325: x_first_trans boolean := TRUE;
1326: x_sysdate DATE := sysdate;
1327: current_n binary_integer := 0;
1328: insert_into_table boolean := FALSE;
1329: x_qty_rcv_exception_code po_line_locations.qty_rcv_exception_code%type;
1330: tax_amount_factor number;
1331: lastrecord boolean := FALSE;
1332: -- Bug# 5739706
1333: l_date_reject boolean := FALSE;
2120: IF x_qty_rcv_exception_code IN ('REJECT','WARNING') then
2121: BEGIN
2122: select quantity, nvl(qty_rcv_tolerance,0)
2123: into l_poll_qty, l_poll_tolerance_pct
2124: from po_line_locations_all
2125: where line_location_id = temp_cascaded_table(current_n).po_line_location_id ;
2126: EXCEPTION
2127: when others then
2128: NULL;