APPS.WMS_CONTAINER_PUB dependencies on DUAL

Line 253: FROM DUAL

249: * Add current status of resides in receiving
250: */
251: CURSOR serial_validation_cursor IS
252: SELECT 'Validate-Serial'
253: FROM DUAL
254: WHERE EXISTS( SELECT 'Subinventory-not-given'
255: FROM mtl_serial_numbers
256: WHERE inventory_item_id = p_container_item_id
257: AND current_organization_id = p_organization_id

Line 1048: FROM DUAL;

1044: /* Need to generate a license plate number to go along with the given lpn id */
1045: LOOP
1046: SELECT wms_license_plate_numbers_s2.NEXTVAL
1047: INTO l_curr_seq
1048: FROM DUAL;
1049:
1050: l_new_lpn := l_org.lpn_prefix || TO_CHAR(l_curr_seq) || l_org.lpn_suffix;
1051: l_lpn.lpn_id := l_new_lpn_id;
1052: l_lpn.license_plate_number := l_new_lpn;

Line 2100: FROM DUAL

2096: * Add current status of resides in receiving
2097: */
2098: CURSOR serial_validation_cursor IS
2099: SELECT 'Validate Serial'
2100: FROM DUAL
2101: WHERE EXISTS( SELECT 'X'
2102: FROM mtl_serial_numbers
2103: WHERE inventory_item_id = p_content_item_id
2104: AND current_organization_id = p_organization_id

Line 2110: FROM DUAL

2106: AND current_status IN (1, 4, 5, 6, 7));
2107:
2108: CURSOR lot_validation_cursor IS
2109: SELECT 'Validate Lot'
2110: FROM DUAL
2111: WHERE EXISTS( SELECT 'X'
2112: FROM mtl_lot_numbers
2113: WHERE inventory_item_id = p_content_item_id
2114: AND organization_id = p_organization_id

Line 2776: FROM DUAL

2772: * Add current status of resides in receiving
2773: */
2774: CURSOR serial_validation_cursor IS
2775: SELECT 'Validate Serial'
2776: FROM DUAL
2777: WHERE EXISTS( SELECT 'X'
2778: FROM mtl_serial_numbers
2779: WHERE inventory_item_id = p_content_item_id
2780: AND current_organization_id = p_organization_id