[Home] [Help]
2241: SELECT rs.rcv_transaction_id
2242: , rsh.receipt_source_code
2243: , rs.unit_of_measure
2244: , rs.secondary_unit_of_measure --OPM Convergence
2245: FROM rcv_supply rs, rcv_transactions rt, rcv_shipment_headers rsh,rcv_shipment_lines rsl --BugFix:14554730
2246: WHERE rs.rcv_transaction_id = rt.transaction_id
2247: AND rsl.shipment_line_id = rs.shipment_line_id --BugFix:14554730
2248: AND rsh.shipment_header_id = rs.shipment_header_id
2249: AND ((rsl.shipment_line_id = k_reference_id AND k_reference='SHIPMENT_LINE_ID') --BugFix:14554730
5296: , l_customer_site_id
5297: , l_customer_item_number
5298: FROM rcv_supply rsup
5299: ,rcv_shipment_headers rsh
5300: ,rcv_shipment_lines rsl
5301: ,rcv_transactions rt
5302: ,po_line_locations pll
5303: ,po_lines pol
5304: ,mtl_system_items msi
5712: IF nvl(v_lcm_enabled_org, 'N') = 'Y' THEN
5713:
5714: SELECT LCM_SHIPMENT_LINE_ID, UNIT_LANDED_COST
5715: INTO v_lcm_ship_line_id, v_unit_landed_cost
5716: FROM rcv_shipment_lines
5717: WHERE shipment_line_id = l_shipment_line_id;
5718:
5719: UPDATE rcv_transactions_interface
5720: SET lcm_shipment_line_id = v_lcm_ship_line_id,
6699:
6700: -- obtain SHIPMENT RECEIPT INFORMATION
6701: SELECT COUNT(DISTINCT rsl.shipment_header_id)
6702: INTO v_count_intshp
6703: FROM mtl_txn_request_lines mtrl, rcv_shipment_lines rsl
6704: WHERE reference = 'SHIPMENT_LINE_ID'
6705: AND mtrl.reference_id = rsl.shipment_line_id
6706: AND mtrl.quantity > nvl(mtrl.quantity_delivered, 0)
6707: AND mtrl.lpn_id = p_lpn_id
6719: x_msg_data := ' ';
6720:
6721: select distinct rsl.shipment_header_id, rsh.shipment_num, rsh.receipt_num
6722: into x_intshp_id, x_intshp_number, x_receipt_number
6723: from mtl_txn_request_lines mtrl, rcv_shipment_lines rsl, rcv_shipment_headers rsh
6724: where reference = 'SHIPMENT_LINE_ID'
6725: and mtrl.quantity > nvl(mtrl.quantity_delivered, 0)
6726: and mtrl.reference_id = rsl.shipment_line_id
6727: and rsl.shipment_header_id = rsh.shipment_header_id