[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
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
3403: ,po_lines pol
3422: print_debug('IN INSERT_INSPECT_REC_RTF ',9);
3423: END IF;
3424: SELECT receipt_num
3425: INTO l_receipt_num
3426: FROM rcv_shipment_headers
3427: WHERE shipment_header_id = l_shipment_hdr_id
3428: AND ship_to_org_id = p_organization_id;
3429:
3430: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;
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
4820: x_msg_data := ' ';
4821:
4822: select distinct rsl.shipment_header_id, rsh.shipment_num, rsh.receipt_num
4823: into x_intshp_id, x_intshp_number, x_receipt_number
4824: from mtl_txn_request_lines mtrl, rcv_shipment_lines rsl, rcv_shipment_headers rsh
4825: where reference = 'SHIPMENT_LINE_ID'
4826: and mtrl.quantity > nvl(mtrl.quantity_delivered, 0)
4827: and mtrl.reference_id = rsl.shipment_line_id
4828: and rsl.shipment_header_id = rsh.shipment_header_id