[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'
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
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
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
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
3394: , l_oe_order_line_id
3395: , l_customer_id
3396: , l_customer_site_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
4215: AND lpn_id = p_lpn_id;
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))
4233:
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
4245: AND rt.routing_header_id = 2; /* Inspection routing */
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
4879: IF (p_source_type = 'PO') THEN
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
4897: ELSE IF (p_source_type IN ('INTSHIP', 'RECEIPT')) THEN
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
4915: ELSE IF (p_source_type = 'RMA') THEN
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