APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 602: from wms_license_plate_numbers wlpn, mtl_system_items_kfv msik

598: p_lpn_id IN NUMBER) IS
599: BEGIN
600: open x_items for
601: select wlpn.inventory_item_id, msik.concatenated_segments
602: from wms_license_plate_numbers wlpn, mtl_system_items_kfv msik
603: where wlpn.lpn_id = p_lpn_id
604: and wlpn.inventory_item_id = msik.inventory_item_id(+);
605: END get_items_in_lpn;
606:

Line 632: FROM WMS_LICENSE_PLATE_NUMBERS

628: and wda2.delivery_detail_id = wdd.delivery_detail_id;
629:
630: CURSOR nested_parent_lpn_cursor(l_inner_lpn_id NUMBER) is
631: SELECT lpn_id
632: FROM WMS_LICENSE_PLATE_NUMBERS
633: START WITH lpn_id = l_inner_lpn_id
634: CONNECT BY lpn_id = PRIOR parent_lpn_id;
635:
636: l_return_status VARCHAR2(1);

Line 730: UPDATE WMS_LICENSE_PLATE_NUMBERS

726: FOR l_par_lpn_id IN nested_parent_lpn_cursor(l_lpn_id) LOOP
727: IF (l_debug = 1) THEN
728: debug('LPN ID'||l_par_lpn_id.lpn_id,'wshtxn');
729: END IF;
730: UPDATE WMS_LICENSE_PLATE_NUMBERS
731: SET lpn_context = 1,
732: last_update_date = SYSDATE,
733: last_updated_by = FND_GLOBAL.USER_ID
734: where lpn_id = l_par_lpn_id.lpn_id;

Line 920: FROM WMS_LICENSE_PLATE_NUMBERS

916: and wda2.delivery_detail_id = wdd.delivery_detail_id;
917:
918: CURSOR nested_parent_lpn_cursor(l_inner_lpn_id NUMBER) is
919: SELECT lpn_id
920: FROM WMS_LICENSE_PLATE_NUMBERS
921: START WITH lpn_id = l_inner_lpn_id
922: CONNECT BY lpn_id = PRIOR parent_lpn_id;
923:
924: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;

Line 1059: UPDATE wms_license_plate_numbers

1055: FOR l_par_lpn_id IN nested_parent_lpn_cursor(l_lpn_id) LOOP
1056: IF l_debug = 1 THEN
1057: debug('l_par_lpn_id.lpn_id: '|| l_par_lpn_id.lpn_id, 'INV_LINE_RETURN_TO_STOCK');
1058: END IF;
1059: UPDATE wms_license_plate_numbers
1060: SET lpn_context = 1,
1061: last_update_date = SYSDATE,
1062: last_updated_by = fnd_global.user_id
1063: WHERE lpn_id = l_par_lpn_id.lpn_id;

Line 1065: debug('Updated wms_license_plate_numbers context 1: ', 'INV_LINE_RETURN_TO_STOCK');

1061: last_update_date = SYSDATE,
1062: last_updated_by = fnd_global.user_id
1063: WHERE lpn_id = l_par_lpn_id.lpn_id;
1064: IF l_debug = 1 THEN
1065: debug('Updated wms_license_plate_numbers context 1: ', 'INV_LINE_RETURN_TO_STOCK');
1066: END IF;
1067: END LOOP;
1068:
1069: --**Check whether Shipping's backorder API does

Line 1239: FROM WMS_LICENSE_PLATE_NUMBERS

1235: and wda2.delivery_detail_id = wdd.delivery_detail_id;
1236:
1237: CURSOR nested_parent_lpn_cursor(l_inner_lpn_id NUMBER) is
1238: SELECT lpn_id
1239: FROM WMS_LICENSE_PLATE_NUMBERS
1240: START WITH lpn_id = l_inner_lpn_id
1241: CONNECT BY lpn_id = PRIOR parent_lpn_id;
1242:
1243: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;

Line 1338: UPDATE wms_license_plate_numbers

1334: WHERE delivery_detail_id = l_parent_delivery_detail_id;
1335:
1336: --update LPN(s) context to Resides in Inventory
1337: FOR l_par_lpn_id IN nested_parent_lpn_cursor(l_lpn_id) LOOP
1338: UPDATE wms_license_plate_numbers
1339: SET lpn_context = 1,
1340: last_update_date = SYSDATE,
1341: last_updated_by = fnd_global.user_id
1342: WHERE lpn_id = l_par_lpn_id.lpn_id;