APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 601: from wms_license_plate_numbers wlpn, mtl_system_items_kfv msik

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

Line 631: FROM WMS_LICENSE_PLATE_NUMBERS

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

Line 729: UPDATE WMS_LICENSE_PLATE_NUMBERS

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

Line 919: FROM WMS_LICENSE_PLATE_NUMBERS

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

Line 1040: UPDATE wms_license_plate_numbers

1036: FOR l_par_lpn_id IN nested_parent_lpn_cursor(l_lpn_id) LOOP
1037: IF l_debug = 1 THEN
1038: debug('l_par_lpn_id.lpn_id: '|| l_par_lpn_id.lpn_id, 'INV_LINE_RETURN_TO_STOCK');
1039: END IF;
1040: UPDATE wms_license_plate_numbers
1041: SET lpn_context = 1,
1042: last_update_date = SYSDATE,
1043: last_updated_by = fnd_global.user_id
1044: WHERE lpn_id = l_par_lpn_id.lpn_id;

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

1042: last_update_date = SYSDATE,
1043: last_updated_by = fnd_global.user_id
1044: WHERE lpn_id = l_par_lpn_id.lpn_id;
1045: IF l_debug = 1 THEN
1046: debug('Updated wms_license_plate_numbers context 1: ', 'INV_LINE_RETURN_TO_STOCK');
1047: END IF;
1048: END LOOP;
1049:
1050: --**Check whether Shipping's backorder API does

Line 1220: FROM WMS_LICENSE_PLATE_NUMBERS

1216: and wda2.delivery_detail_id = wdd.delivery_detail_id;
1217:
1218: CURSOR nested_parent_lpn_cursor(l_inner_lpn_id NUMBER) is
1219: SELECT lpn_id
1220: FROM WMS_LICENSE_PLATE_NUMBERS
1221: START WITH lpn_id = l_inner_lpn_id
1222: CONNECT BY lpn_id = PRIOR parent_lpn_id;
1223:
1224: l_delivery_details_id_table WSH_UTIL_CORE.ID_TAB_TYPE;

Line 1319: UPDATE wms_license_plate_numbers

1315: WHERE delivery_detail_id = l_parent_delivery_detail_id;
1316:
1317: --update LPN(s) context to Resides in Inventory
1318: FOR l_par_lpn_id IN nested_parent_lpn_cursor(l_lpn_id) LOOP
1319: UPDATE wms_license_plate_numbers
1320: SET lpn_context = 1,
1321: last_update_date = SYSDATE,
1322: last_updated_by = fnd_global.user_id
1323: WHERE lpn_id = l_par_lpn_id.lpn_id;