82: from PJM_PROJECTS_ORG_V ppovs
83: ,MTL_ITEM_LOCATIONS mil
84: ,
85: MTL_LOT_NUMBERS mlna ,
86: WMS_TRX_DETAILS_TMP_V mptdtv
87: ,(
88: select msn.current_organization_id organization_id
89: ,msn.inventory_item_id
90: ,msn.revision
177: from PJM_PROJECTS_ORG_V ppovs
178: ,MTL_ITEM_LOCATIONS mil
179: ,
180: MTL_LOT_NUMBERS mlna ,
181: WMS_TRX_DETAILS_TMP_V mptdtv
182: ,(
183: select msn.current_organization_id organization_id
184: ,msn.inventory_item_id
185: ,msn.revision
288: from PJM_PROJECTS_ORG_V ppovs
289: ,MTL_ITEM_LOCATIONS mil
290: ,
291: MTL_LOT_NUMBERS mlna ,
292: WMS_TRX_DETAILS_TMP_V mptdtv
293: ,(
294: select msn.current_organization_id organization_id
295: ,msn.inventory_item_id
296: ,msn.revision
396: from PJM_PROJECTS_ORG_V ppovs
397: ,MTL_ITEM_LOCATIONS mil
398: ,
399: MTL_LOT_NUMBERS mlna ,
400: WMS_TRX_DETAILS_TMP_V mptdtv
401: ,(
402: SELECT x.organization_id organization_id
403: ,x.inventory_item_id inventory_item_id
404: ,x.revision revision