[Home] [Help]
410: SELECT rs.rcv_transaction_id
411: , rsh.receipt_source_code
412: , rs.unit_of_measure
413: , rs.secondary_unit_of_measure --OPM Convergence
414: FROM rcv_supply rs, rcv_transactions rt, rcv_shipment_headers rsh
415: WHERE rs.rcv_transaction_id = rt.transaction_id
416: AND rsh.shipment_header_id = rs.shipment_header_id
417: AND rt.inspection_status_code = 'NOT INSPECTED'
418: AND rs.supply_type_code = 'RECEIVING'
431: , rsh.receipt_source_code
432: , rs.unit_of_measure
433: , rs.secondary_unit_of_measure --OPM Convergence
434: , rls.quantity quantity
435: FROM rcv_supply rs, rcv_lots_supply rls, rcv_transactions rt, rcv_shipment_headers rsh
436: WHERE rs.rcv_transaction_id = rt.transaction_id
437: AND rsh.shipment_header_id = rs.shipment_header_id
438: AND rt.inspection_status_code = 'NOT INSPECTED'
439: AND rs.supply_type_code = 'RECEIVING'
454: SELECT rs.rcv_transaction_id
455: , rsh.receipt_source_code
456: , rs.unit_of_measure
457: , rs.secondary_unit_of_measure --OPM Convergence
458: FROM rcv_supply rs, rcv_serials_supply rss, rcv_transactions rt, rcv_shipment_headers rsh
459: WHERE rs.rcv_transaction_id = rt.transaction_id
460: AND rsh.shipment_header_id = rs.shipment_header_id
461: AND rt.inspection_status_code = 'NOT INSPECTED'
462: AND rs.supply_type_code = 'RECEIVING'
631: IF (l_debug = 1) THEN
632: print_debug('main process: l_remaining_mol_qty = min(l_mol_qty, l_remaining_qty) = ' || l_remaining_mol_qty, 4);
633: END IF;
634:
635: -- Open Rcv Transactions cursor
636: -- MOLCON
637: IF (l_serial_number IS NOT NULL) THEN
638: OPEN rtv_serial_cursor(
639: l_inventory_item_id
745: BEGIN
746: SELECT SUM(Nvl(mtli.primary_quantity,0))
747: INTO l_processed_lot_prim_qty
748: FROM mtl_transaction_lots_interface mtli
749: , rcv_transactions_interface rti
750: WHERE mtli.product_code = 'RCV'
751: AND mtli.product_transaction_id = rti.interface_transaction_id
752: AND mtli.lot_number = l_lot_number
753: AND rti.parent_transaction_id = l_rcv_transaction_id
1569: select
1570: rcv_transaction_id
1571: , receipt_source_code
1572: , unit_of_measure
1573: from rcv_transactions_v
1574: where po_header_id = k_po_header_id
1575: and to_organization_id = k_organization_id
1576: and item_id = k_inventory_item_id
1577: and (item_revision = k_revision OR
1592: rs.rcv_transaction_id
1593: , rsh.receipt_source_code
1594: , rs.unit_of_measure
1595: , rs.secondary_unit_of_measure --OPM Convergence
1596: from rcv_supply rs, rcv_transactions rt, rcv_shipment_headers rsh
1597: where rs.po_header_id = k_po_header_id
1598: and rs.to_organization_id = k_organization_id
1599: and rs.item_id = k_inventory_item_id
1600: and (k_revision_control = 2
1674:
1675: END IF;
1676: -- dbms_output.put_line('main_process_po: Convert inspection uom code into uom');
1677:
1678: -- Open RCV Transactions V cursor
1679: open rtv_cursor(
1680: l_po_header_id
1681: , l_organization_id
1682: , l_inventory_item_id
1983: select
1984: rcv_transaction_id
1985: , receipt_source_code
1986: , unit_of_measure
1987: from rcv_transactions_v
1988: where receipt_source_code <> 'VENDOR'
1989: and shipment_header_id = k_shipment_header_id
1990: and to_organization_id = k_organization_id
1991: and item_id = k_inventory_item_id
2007: rs.rcv_transaction_id
2008: , rsh.receipt_source_code
2009: , rs.unit_of_measure
2010: , rs.secondary_unit_of_measure --OPM Convergence
2011: from rcv_supply rs, rcv_transactions rt, rcv_shipment_headers rsh
2012: where rsh.receipt_source_code <> 'VENDOR'
2013: and rs.shipment_header_id = k_shipment_header_id
2014: and rs.to_organization_id = k_organization_id
2015: and rs.item_id = k_inventory_item_id
2090: END IF;
2091:
2092: -- dbms_output.put_line('main_process_intransit: Convert inspection uom code into uom');
2093:
2094: -- Open RCV Transactions V cursor
2095: open rtv_cursor(
2096: l_shipment_header_id
2097: , l_organization_id
2098: , l_inventory_item_id
2398: select
2399: rcv_transaction_id
2400: , receipt_source_code
2401: , unit_of_measure
2402: from rcv_transactions_v
2403: where receipt_source_code = 'CUSTOMER'
2404: and oe_order_header_id = k_oe_order_header_id
2405: and to_organization_id = k_organization_id
2406: and item_id = k_inventory_item_id
2422: rs.rcv_transaction_id
2423: , rsh.receipt_source_code
2424: , rs.unit_of_measure
2425: , rs.secondary_unit_of_measure --OPM Convergence
2426: from rcv_supply rs, rcv_transactions rt, rcv_shipment_headers rsh
2427: where rsh.receipt_source_code = 'CUSTOMER'
2428: and rs.oe_order_header_id = k_oe_order_header_id
2429: and rs.to_organization_id = k_organization_id
2430: and rs.item_id = k_inventory_item_id
2503:
2504: END IF;
2505: -- dbms_output.put_line('main_process_rma: Convert inspection uom code into uom');
2506:
2507: -- Open RCV Transactions V cursor
2508: open rtv_cursor(
2509: l_oe_order_header_id
2510: , l_organization_id
2511: , l_inventory_item_id
2808: select
2809: rcv_transaction_id
2810: , receipt_source_code
2811: , unit_of_measure
2812: from rcv_transactions_v
2813: where receipt_num = k_receipt_num
2814: and to_organization_id = k_organization_id
2815: and item_id = k_inventory_item_id
2816: and (item_revision = k_revision OR
2831: rs.rcv_transaction_id
2832: , rsh.receipt_source_code
2833: , rs.unit_of_measure
2834: , rs.secondary_unit_of_measure --OPM Convergence
2835: from rcv_supply rs, rcv_transactions rt, rcv_shipment_headers rsh
2836: where rsh.receipt_num = k_receipt_num
2837: and rs.to_organization_id = k_organization_id
2838: and rs.item_id = k_inventory_item_id
2839: and (k_revision_control = 2
2911:
2912: END IF;
2913: -- dbms_output.put_line('main_process_receipt: Convert inspection uom code into uom');
2914:
2915: -- Open RCV Transactions V cursor
2916: open rtv_cursor(
2917: l_receipt_num
2918: , l_organization_id
2919: , l_inventory_item_id
3397: , l_customer_item_number
3398: FROM rcv_supply rsup
3399: ,rcv_shipment_headers rsh
3400: ,rcv_shipment_lines rsl
3401: ,rcv_transactions rt
3402: ,po_line_locations pll
3403: ,po_lines pol
3404: ,mtl_system_items msi
3405: ,mtl_customer_items mci
3457: ELSE
3458: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
3459: END IF;
3460:
3461: select rcv_transactions_interface_s.nextval
3462: into l_interface_transaction_id from dual;
3463:
3464:
3465: if l_inspection_code = 'ACCEPT' then
3469: end if;
3470:
3471: SELECT RT.MOVEMENT_ID
3472: INTO l_movement_id
3473: FROM RCV_TRANSACTIONS RT
3474: WHERE RT.TRANSACTION_ID = l_rcv_transaction_id;
3475:
3476: --
3477: l_operating_unit_id := inv_rcv_common_apis.get_operating_unit_id( l_receipt_source_code,
3602: ELSE
3603: l_transaction_date := Trunc(Sysdate);
3604: END IF;
3605:
3606: insert into RCV_TRANSACTIONS_INTERFACE
3607: (
3608: receipt_source_code,
3609: interface_transaction_id,
3610: group_id,
3815: INTO v_lcm_ship_line_id, v_unit_landed_cost
3816: FROM rcv_shipment_lines
3817: WHERE shipment_line_id = l_shipment_line_id;
3818:
3819: UPDATE rcv_transactions_interface
3820: SET lcm_shipment_line_id = v_lcm_ship_line_id,
3821: unit_landed_cost = v_unit_landed_cost
3822: WHERE interface_transaction_id = l_interface_transaction_id
3823: AND to_organization_id = l_organization_id;
3995: -- Bug 2377796
3996: -- LPN lables are not getting printed for rejected LPNS
3997: --SELECT MIN(rti.interface_transaction_id)
3998: SELECT rti.interface_transaction_id
3999: FROM rcv_transactions_interface rti
4000: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
4001: -- GROUP BY rti.lpn_id;
4002: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4003: BEGIN
4216:
4217: CURSOR c_po_source_lines IS
4218: SELECT rs.rcv_transaction_id
4219: FROM rcv_supply rs
4220: , rcv_transactions rt
4221: WHERE rs.item_id = p_item_id
4222: AND rs.po_header_id = p_po_header_id
4223: AND nvl(rs.po_release_id,-1) = nvl(p_po_release_id,nvl(rs.po_release_id,-1))
4224: AND nvl(rs.po_line_id,-1) = nvl(p_po_line_id, nvl(rs.po_line_id,-1))
4234: -- use this for receipts also --
4235: CURSOR c_intship_source_lines IS
4236: SELECT rs.rcv_transaction_id
4237: FROM rcv_supply rs
4238: , rcv_transactions rt
4239: WHERE rs.item_id = p_item_id
4240: AND rs.shipment_header_id = p_shipment_header_id
4241: AND rs.rcv_transaction_id = rt.transaction_id
4242: AND rt.inspection_status_code = 'NOT INSPECTED'
4246:
4247: CURSOR c_rma_source_lines IS
4248: SELECT rs.rcv_transaction_id
4249: FROM rcv_supply rs
4250: , rcv_transactions rt
4251: WHERE rs.item_id = p_item_id
4252: AND rs.oe_order_header_id = p_oe_order_header_id
4253: AND rs.rcv_transaction_id = rt.transaction_id
4254: AND rt.inspection_status_code = 'NOT INSPECTED'
4680: begin
4681: -- obtain receipt number
4682: select distinct rsh.receipt_num, '0'
4683: into x_receipt_number, x_receipt_return_status
4684: from mtl_txn_request_lines mtrl, rcv_transactions rt, rcv_shipment_headers rsh
4685: where reference = 'PO_LINE_LOCATION_ID'
4686: and mtrl.reference_id = rt.po_line_location_id
4687: and mtrl.quantity > nvl(mtrl.quantity_delivered, 0)
4688: and rt.shipment_header_id = rsh.shipment_header_id
4762: begin
4763: --obtain the receipt number
4764: select distinct rsh.receipt_num, '0'
4765: into x_receipt_number, x_receipt_return_status
4766: from mtl_txn_request_lines mtrl, rcv_transactions rt, rcv_shipment_headers rsh
4767: where reference = 'ORDER_LINE_ID'
4768: and mtrl.reference_id = rt.oe_order_line_id
4769: and mtrl.quantity > nvl(mtrl.quantity_delivered, 0)
4770: and rt.shipment_header_id = rsh.shipment_header_id
4880: BEGIN
4881: SELECT 1
4882: INTO l_count
4883: FROM rcv_supply rs
4884: , rcv_transactions rt
4885: WHERE rs.item_id = p_item_id
4886: AND rs.item_revision IS NULL
4887: AND rs.po_header_id = p_source_id
4888: AND rs.rcv_transaction_id = rt.transaction_id
4898: BEGIN
4899: SELECT 1
4900: INTO l_count
4901: FROM rcv_supply rs
4902: , rcv_transactions rt
4903: WHERE rs.item_id = p_item_id
4904: AND rs.item_revision IS NULL
4905: AND rs.shipment_header_id = p_source_id
4906: AND rs.rcv_transaction_id = rt.transaction_id
4916: BEGIN
4917: SELECT 1
4918: INTO l_count
4919: FROM rcv_supply rs
4920: , rcv_transactions rt
4921: WHERE rs.item_id = p_item_id
4922: AND rs.item_revision IS NULL
4923: AND rs.oe_order_header_id = p_source_id
4924: AND rs.rcv_transaction_id = rt.transaction_id