APPS.WMS_LMS_EXPECTED_RES dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 300: mtl_material_transactions_temp

296: FND_GLOBAL.LOGIN_ID,
297: FND_GLOBAL.USER_ID,
298: SYSDATE
299: from
300: mtl_material_transactions_temp
301: where organization_id = p_org_id
302: and transaction_type_id = 18
303: and transaction_action_id =27
304: and transaction_source_type_id =1

Line 373: mtl_material_transactions_temp

369: FND_GLOBAL.LOGIN_ID,
370: FND_GLOBAL.USER_ID,
371: SYSDATE
372: from
373: mtl_material_transactions_temp
374: where organization_id = p_org_id
375: and transaction_type_id = 15
376: and transaction_action_id =27
377: and transaction_source_type_id =12

Line 446: mtl_material_transactions_temp

442: FND_GLOBAL.LOGIN_ID,
443: FND_GLOBAL.USER_ID,
444: SYSDATE
445: from
446: mtl_material_transactions_temp
447: where organization_id = p_org_id
448: and transaction_type_id = 12
449: and transaction_action_id =12
450: and transaction_source_type_id =13

Line 519: mtl_material_transactions_temp

515: FND_GLOBAL.LOGIN_ID,
516: FND_GLOBAL.USER_ID,
517: SYSDATE
518: from
519: mtl_material_transactions_temp
520: where organization_id = p_org_id
521: and transaction_type_id = 61
522: and transaction_action_id =12
523: and transaction_source_type_id =7

Line 590: from mtl_material_transactions_temp

586: SYSDATE,
587: FND_GLOBAL.LOGIN_ID,
588: FND_GLOBAL.USER_ID,
589: SYSDATE
590: from mtl_material_transactions_temp
591: where organization_id = p_org_id
592: and transaction_type_id = 44
593: and transaction_action_id =31
594: and transaction_source_type_id =5

Line 862: mtl_material_transactions_temp mmtt

858: FND_GLOBAL.LOGIN_ID,
859: FND_GLOBAL.USER_ID,
860: SYSDATE
861: from
862: mtl_material_transactions_temp mmtt
863: where
864: mmtt.organization_id = p_org_id
865: and
866: (

Line 1103: mtl_material_transactions_temp mmtt,

1099: FND_GLOBAL.LOGIN_ID,
1100: FND_GLOBAL.USER_ID,
1101: SYSDATE
1102: from
1103: mtl_material_transactions_temp mmtt,
1104: wms_dispatched_tasks wdt
1105: where
1106: mmtt.organization_id = p_org_id
1107: and

Line 1321: mtl_material_transactions_temp mmtt

1317: FND_GLOBAL.LOGIN_ID,
1318: FND_GLOBAL.USER_ID,
1319: SYSDATE
1320: from
1321: mtl_material_transactions_temp mmtt
1322: where
1323: mmtt.organization_id = p_org_id
1324: and
1325: (

Line 1532: mtl_material_transactions_temp mmtt,

1528: FND_GLOBAL.LOGIN_ID,
1529: FND_GLOBAL.USER_ID,
1530: SYSDATE
1531: from
1532: mtl_material_transactions_temp mmtt,
1533: wms_dispatched_tasks wdt
1534: where
1535: mmtt.organization_id = p_org_id
1536: and

Line 1729: mtl_material_transactions_temp mmtt1,

1725: FND_GLOBAL.LOGIN_ID,
1726: FND_GLOBAL.USER_ID,
1727: SYSDATE
1728: from
1729: mtl_material_transactions_temp mmtt1,
1730: mtl_material_transactions_temp mmtt2,
1731: wms_dispatched_tasks wdt
1732: where
1733: mmtt1.organization_id = p_org_id

Line 1730: mtl_material_transactions_temp mmtt2,

1726: FND_GLOBAL.USER_ID,
1727: SYSDATE
1728: from
1729: mtl_material_transactions_temp mmtt1,
1730: mtl_material_transactions_temp mmtt2,
1731: wms_dispatched_tasks wdt
1732: where
1733: mmtt1.organization_id = p_org_id
1734: and mmtt2.organization_id = p_org_id

Line 1865: mtl_material_transactions_temp

1861: 1 group_id --manual and user directed
1862: FROM
1863: (SELECT lpn_id,transfer_to_location,count(*) num_lines
1864: FROM
1865: mtl_material_transactions_temp
1866: WHERE organization_id = p_org_id
1867: AND transaction_type_id = 64
1868: AND transaction_action_id =2
1869: AND transaction_source_type_id =4

Line 1871: GROUP BY lpn_id,transfer_to_location ) tab1, mtl_material_transactions_temp mmtt

1867: AND transaction_type_id = 64
1868: AND transaction_action_id =2
1869: AND transaction_source_type_id =4
1870: AND wms_task_type =2
1871: GROUP BY lpn_id,transfer_to_location ) tab1, mtl_material_transactions_temp mmtt
1872: WHERE mmtt.lpn_id = tab1.lpn_id
1873: AND mmtt.transfer_to_location = tab1.transfer_to_location
1874: );
1875:

Line 1964: mtl_material_transactions_temp

1960: mmtt.operation_plan_id,
1961: 1 group_id --manual and user directed
1962: from
1963: (select content_lpn_id,locator_id,count(*) num_lines from
1964: mtl_material_transactions_temp
1965: where organization_id = p_org_id
1966: and transaction_type_id = 2
1967: and transaction_action_id =2
1968: and transaction_source_type_id =13

Line 1970: group by content_lpn_id,locator_id ) tab1, mtl_material_transactions_temp mmtt

1966: and transaction_type_id = 2
1967: and transaction_action_id =2
1968: and transaction_source_type_id =13
1969: AND wms_task_type =7
1970: group by content_lpn_id,locator_id ) tab1, mtl_material_transactions_temp mmtt
1971: where mmtt.content_lpn_id = tab1.content_lpn_id
1972: and mmtt.locator_id = tab1.locator_id
1973: );
1974: