[Home] [Help]
21: CURSOR c_changed( b_last_date DATE ) IS
22: SELECT acc.ACCESS_ID, acc.RESOURCE_ID
23: FROM CSL_MTL_SECONDARY_LOCATORS_ACC acc
24: , MTL_SECONDARY_LOCATORS b
25: , ASG_USER au
26: WHERE b.SECONDARY_LOCATOR = acc.SECONDARY_LOCATOR
27: AND b.ORGANIZATION_ID = acc.ORGANIZATION_ID
28: AND b.INVENTORY_ITEM_ID = acc.INVENTORY_ITEM_ID
29: AND au.RESOURCE_ID = acc.RESOURCE_ID
96: IS
97: CURSOR c_inserted( b_last_date DATE )
98: IS SELECT CSL_ACC_SEQUENCE.NEXTVAL, I.RESOURCE_ID, S.INVENTORY_ITEM_ID, S.SECONDARY_LOCATOR, S.ORGANIZATION_ID, I.COUNTER
99: FROM MTL_SECONDARY_LOCATORS S, CSL_MTL_ITEM_LOCATIONS_ACC A,
100: JTM_MTL_SYSTEM_ITEMS_ACC I, ASG_USER U
101: WHERE S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
102: AND S.ORGANIZATION_ID = I.ORGANIZATION_ID
103: AND S.SECONDARY_LOCATOR = A.INVENTORY_LOCATION_ID
104: AND S.ORGANIZATION_ID = A.ORGANIZATION_ID
144: , LAST_UPDATED_BY = 1
145: WHERE ( RESOURCE_ID, INVENTORY_ITEM_ID, SECONDARY_LOCATOR, ORGANIZATION_ID ) IN
146: ( SELECT I.RESOURCE_ID, S.INVENTORY_ITEM_ID, S.SECONDARY_LOCATOR, S.ORGANIZATION_ID
147: FROM MTL_SECONDARY_LOCATORS S, CSL_MTL_ITEM_LOCATIONS_ACC A,
148: JTM_MTL_SYSTEM_ITEMS_ACC I, ASG_USER U
149: WHERE S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
150: AND S.ORGANIZATION_ID = I.ORGANIZATION_ID
151: AND S.SECONDARY_LOCATOR = A.INVENTORY_LOCATION_ID
152: AND S.ORGANIZATION_ID = A.ORGANIZATION_ID
368: PRAGMA AUTONOMOUS_TRANSACTION;
369: CURSOR c_inserted
370: IS SELECT CSL_ACC_SEQUENCE.NEXTVAL, I.RESOURCE_ID, S.INVENTORY_ITEM_ID, S.SECONDARY_LOCATOR, S.ORGANIZATION_ID, I.COUNTER
371: FROM MTL_SECONDARY_LOCATORS S, CSL_MTL_ITEM_LOCATIONS_ACC A,
372: JTM_MTL_SYSTEM_ITEMS_ACC I, ASG_USER U
373: WHERE S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
374: AND S.ORGANIZATION_ID = I.ORGANIZATION_ID
375: AND S.SECONDARY_LOCATOR = A.INVENTORY_LOCATION_ID
376: AND S.ORGANIZATION_ID = A.ORGANIZATION_ID