APPS.WMS_CONTAINER_PUB dependencies on DUAL

Line 178: FROM DUAL

174: * Add current status of resides in receiving
175: */
176: CURSOR serial_validation_cursor IS
177: SELECT 'Validate-Serial'
178: FROM DUAL
179: WHERE EXISTS( SELECT 'Subinventory-not-given'
180: FROM mtl_serial_numbers
181: WHERE inventory_item_id = p_container_item_id
182: AND current_organization_id = p_organization_id

Line 971: FROM DUAL;

967: /* Need to generate a license plate number to go along with the given lpn id */
968: LOOP
969: SELECT wms_license_plate_numbers_s2.NEXTVAL
970: INTO l_curr_seq
971: FROM DUAL;
972:
973: l_new_lpn := l_org.lpn_prefix || TO_CHAR(l_curr_seq) || l_org.lpn_suffix;
974: l_lpn.lpn_id := l_new_lpn_id;
975: l_lpn.license_plate_number := l_new_lpn;

Line 2023: FROM DUAL

2019: * Add current status of resides in receiving
2020: */
2021: CURSOR serial_validation_cursor IS
2022: SELECT 'Validate Serial'
2023: FROM DUAL
2024: WHERE EXISTS( SELECT 'X'
2025: FROM mtl_serial_numbers
2026: WHERE inventory_item_id = p_content_item_id
2027: AND current_organization_id = p_organization_id

Line 2033: FROM DUAL

2029: AND current_status IN (1, 4, 5, 6, 7));
2030:
2031: CURSOR lot_validation_cursor IS
2032: SELECT 'Validate Lot'
2033: FROM DUAL
2034: WHERE EXISTS( SELECT 'X'
2035: FROM mtl_lot_numbers
2036: WHERE inventory_item_id = p_content_item_id
2037: AND organization_id = p_organization_id

Line 2698: FROM DUAL

2694: * Add current status of resides in receiving
2695: */
2696: CURSOR serial_validation_cursor IS
2697: SELECT 'Validate Serial'
2698: FROM DUAL
2699: WHERE EXISTS( SELECT 'X'
2700: FROM mtl_serial_numbers
2701: WHERE inventory_item_id = p_content_item_id
2702: AND current_organization_id = p_organization_id