APPS.WSMPINVL dependencies on WSM_SOURCE_LOTS_V

Line 1095: from wsm_source_lots_v

1091: --bugfix 1823316
1092:
1093: cursor lot (org_id NUMBER, lot_n VARCHAR2) is
1094: select inventory_item_id, subinventory_code, locator_id, revision, quantity
1095: from wsm_source_lots_v
1096: where lot_number = lot_n
1097: and organization_id = org_id;
1098: --end 1823316
1099:

Line 1348: ** Check if this lot exists with this organization in WSM_SOURCE_LOTS_V

1344: return;
1345: END;
1346: */
1347: /*
1348: ** Check if this lot exists with this organization in WSM_SOURCE_LOTS_V
1349: ** If Yes, then select inventory_item_id, subinventory_code, locator_id, revision
1350: ** quantity and then validate it.
1351: */
1352:

Line 1359: FROM WSM_SOURCE_LOTS_V

1355: lProcLocation := 50;
1356: SELECT inventory_item_id, subinventory_code,
1357: locator_id, revision, quantity
1358: into x_item_id, x_sub, x_locator_id, x_revision, x_quantity
1359: FROM WSM_SOURCE_LOTS_V
1360: WHERE lot_number = crec.lot_number
1361: AND organization_id = crec.organization_id;
1362:
1363: EXCEPTION