[Home] [Help]
764: g_shipment_header_id := l_rcv_transaction_rec.rcv_shipment_header_id;
765: END IF;
766:
767: IF g_shipment_header_id IS NULL THEN
768: SELECT rcv_shipment_headers_s.NEXTVAL
769: INTO g_shipment_header_id
770: FROM DUAL;
771: END IF;
772:
2643: , NULL task_id
2644: , NULL secondary_uom --OPM Convergence
2645: , NULL secondary_uom_code --OPM Convergence
2646: , NULL secondary_quantity --OPM Convergence temp
2647: FROM rcv_shipment_headers rsh
2648: , rcv_shipment_lines rsl
2649: , po_requisition_headers porh
2650: , po_requisition_lines porl
2651: , mtl_system_items msi
2696:
2697: -- query po_startup_value
2698: BEGIN
2699: /* Bug #2516729
2700: * Fetch rcv_shipment_headers.receipt_number for the given shipment_header_id.
2701: * If it exists , assign it to the global variable for receipt # (g_rcv_global_var.receipt_num)
2702: * in order that a new receipt # is not created everytime and the existing receipt # is used
2703: */
2704: BEGIN
2703: */
2704: BEGIN
2705: SELECT receipt_num
2706: INTO l_receipt_num
2707: FROM rcv_shipment_headers
2708: WHERE shipment_header_id = p_shipment_header_id
2709: AND ship_to_org_id = p_organization_id;
2710:
2711: --Bug 4252372
3915: , NULL secondary_uom --OPM Convergence
3916: , NULL secondary_uom_code --OPM Convergence
3917: , NULL secondary_quantity --OPM Convergence
3918: FROM rcv_shipment_lines rsl
3919: , rcv_shipment_headers rsh
3920: , po_headers poh
3921: , po_line_locations poll
3922: , po_lines pol
3923: , po_releases por
4086: , NULL task_id
4087: , NULL secondary_uom --OPM Convergence
4088: , NULL secondary_uom_code --OPM Convergence
4089: , NULL secondary_quantity --OPM Convergence temp
4090: FROM rcv_shipment_headers rsh
4091: , rcv_shipment_lines rsl
4092: , po_requisition_headers porh
4093: , po_requisition_lines porl
4094: , mtl_system_items msi
4143:
4144: -- query po_startup_value
4145: BEGIN
4146: /* Bug #2516729
4147: * Fetch rcv_shipment_headers.receipt_number for the given shipment_header_id.
4148: * If it exists , assign it to the global variable for receipt # (g_rcv_global_var.receipt_num)
4149: * in order that a new receipt # is not created everytime and the existing receipt # is used
4150: */
4151: BEGIN
4150: */
4151: BEGIN
4152: SELECT receipt_num
4153: INTO l_receipt_num
4154: FROM rcv_shipment_headers
4155: WHERE shipment_header_id = p_shipment_header_id
4156: AND ship_to_org_id = p_organization_id;
4157:
4158: /* Bug# 6339752 the global variable inv_rcv_common_apis.g_rcv_global_var.receipt_num is to be set only if
4846: , lpnc.lot_number
4847: , lpn.organization_id
4848: , msi.serial_number_control_code
4849: , msi.primary_uom_code
4850: FROM wms_lpn_contents lpnc, wms_license_plate_numbers lpn, mtl_system_items_b msi, rcv_shipment_headers rsh
4851: WHERE rsh.shipment_header_id = p_shipment_header_id
4852: AND(lpn.source_header_id = rsh.shipment_header_id
4853: OR lpn.source_name = rsh.shipment_num)
4854: AND lpn.lpn_context IN(6, 7) -- only those pre-ASN receiving ones
6448: BEGIN
6449: SELECT rsl.po_line_location_id,rsl.po_distribution_id,
6450: decode(rsh.asn_type,'ASN','Y','N'),Decode(rsh.receipt_source_code,'INTERNAL ORDER','Y','N')
6451: INTO l_po_line_location_id,l_po_distribution_id,l_is_asn,l_is_req
6452: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh
6453: WHERE rsl.shipment_line_id = p_shipment_line_id
6454: AND rsl.shipment_header_id = rsh.shipment_header_id;
6455: EXCEPTION
6456: WHEN OTHERS THEN
7116: l_header.attribute14 := p_attribute14;
7117: l_header.attribute15 := p_attribute15;
7118:
7119: IF (l_debug = 1) THEN
7120: print_debug('rcv_insert_header_interface 20: before rcv_shipment_headers_pkg.insert_row ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')
7121: , 1);
7122: END IF;
7123:
7124: l_progress := '20';
7433: --wms_asn_Details for the item
7434: BEGIN
7435: SELECT NVL(ASN_TYPE,'@@@')
7436: INTO l_check_asn
7437: FROM rcv_shipment_headers
7438: WHERE shipment_header_id = g_shipment_header_id;
7439: EXCEPTION
7440: WHEN OTHERS THEN
7441: IF (l_debug = 1) THEN
8109: , x_msg_data OUT NOCOPY VARCHAR2
8110: ) IS
8111: CURSOR l_curs_remaining_asn IS --modified for bug 4951745
8112: SELECT 1
8113: FROM wms_lpn_contents_v lpnc, wms_license_plate_numbers lpn, rcv_shipment_headers rsh
8114: WHERE (lpn.source_header_id = rsh.shipment_header_id
8115: OR lpn.source_name = rsh.shipment_num)
8116: AND rsh.shipment_header_id = p_shipment_header_id
8117: AND (p_lpn_id IS NULL OR lpn.lpn_id=p_lpn_id)
8126:
8127: --Added for Bug 4951745
8128: CURSOR l_curs_remaining_asn_has_lpn IS
8129: SELECT 1
8130: FROM wms_lpn_contents_v lpnc, wms_license_plate_numbers lpn, rcv_shipment_headers rsh
8131: WHERE (lpn.source_header_id = rsh.shipment_header_id
8132: OR lpn.source_name = rsh.shipment_num)
8133: AND rsh.shipment_header_id = p_shipment_header_id
8134: AND lpn.lpn_id = p_lpn_id
8301: CURSOR l_curs_lpn_for_ship IS
8302: SELECT lpn_id
8303: FROM wms_license_plate_numbers
8304: WHERE source_name = (SELECT shipment_num
8305: FROM rcv_shipment_headers
8306: WHERE shipment_header_id = p_shipment_header_id);
8307:
8308: CURSOR l_curs_lpn_for_asn IS
8309: SELECT lpn_id
8325: END IF;
8326:
8327: SELECT SUBSTR(asn_type, 1, 3)
8328: INTO l_asn_type
8329: FROM rcv_shipment_headers
8330: WHERE shipment_header_id = p_shipment_header_id;
8331:
8332: IF (l_debug = 1) THEN
8333: print_debug('clear_LPN_for_ship 10.2 ASN_TYPE =: ' || l_asn_type, 1);
8583: BEGIN
8584: SELECT 1
8585: INTO l_lot_serial_flag
8586: FROM rcv_shipment_lines rsl
8587: , rcv_shipment_headers rsh
8588: , mtl_system_items msi1
8589: , mtl_system_items msi2
8590: WHERE rsh.shipment_num = p_shipment_number
8591: AND rsl.shipment_header_id = rsh.shipment_header_id
8676: BEGIN
8677: SELECT 1
8678: INTO l_lot_serial_flag
8679: FROM rcv_shipment_lines rsl
8680: , rcv_shipment_headers rsh
8681: , mtl_system_items msi1
8682: , mtl_system_items msi2
8683: WHERE rsh.shipment_header_id = p_shipment_header_id
8684: AND rsl.shipment_header_id = rsh.shipment_header_id