eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_TXN_MANAGER_GRP dependencies on WMS_CONTAINER_PUB

Line 3950: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV, WMS_CONTAINER_PUB.LPN_CONTEXT_WIP, WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED, WMS_CONTAINER_PUB.LPN_PREPACK_FOR_WIP)

3946: /* for bug 6903894 */
3947: AND (
3948: --WIP Assembly Completion
3949: ((TRANSACTION_TYPE_ID = 44) OR (TRANSACTION_SOURCE_TYPE_ID = 5 and TRANSACTION_ACTION_ID = 31))
3950: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV, WMS_CONTAINER_PUB.LPN_CONTEXT_WIP, WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED, WMS_CONTAINER_PUB.LPN_PREPACK_FOR_WIP)
3951:
3952: OR
3953: --Account Alias Issue
3954: ((TRANSACTION_TYPE_ID = 31) OR (TRANSACTION_SOURCE_TYPE_ID = 6 and TRANSACTION_ACTION_ID = 1))

Line 3955: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED)

3951:
3952: OR
3953: --Account Alias Issue
3954: ((TRANSACTION_TYPE_ID = 31) OR (TRANSACTION_SOURCE_TYPE_ID = 6 and TRANSACTION_ACTION_ID = 1))
3955: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED)
3956:
3957: OR --bug10009302
3958: --Miscellaneous Receipt
3959: ( (TRANSACTION_TYPE_ID = 42) OR (TRANSACTION_SOURCE_TYPE_ID = 13 and TRANSACTION_ACTION_ID = 27)

Line 3961: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED)

3957: OR --bug10009302
3958: --Miscellaneous Receipt
3959: ( (TRANSACTION_TYPE_ID = 42) OR (TRANSACTION_SOURCE_TYPE_ID = 13 and TRANSACTION_ACTION_ID = 27)
3960: OR (TRANSACTION_SOURCE_TYPE_ID >= 100 and TRANSACTION_ACTION_ID = 27) ) /*Bug11858317 */
3961: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED)
3962:
3963: OR
3964: --Miscellaneous Issue
3965: ((TRANSACTION_TYPE_ID = 32) OR (TRANSACTION_SOURCE_TYPE_ID = 13 and TRANSACTION_ACTION_ID = 1))

Line 3966: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED)

3962:
3963: OR
3964: --Miscellaneous Issue
3965: ((TRANSACTION_TYPE_ID = 32) OR (TRANSACTION_SOURCE_TYPE_ID = 13 and TRANSACTION_ACTION_ID = 1))
3966: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED)
3967:
3968: OR
3969: --Issue Components to WIP
3970: ((TRANSACTION_TYPE_ID = 35) OR (TRANSACTION_SOURCE_TYPE_ID = 5 and TRANSACTION_ACTION_ID = 1))

Line 3971: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV)

3967:
3968: OR
3969: --Issue Components to WIP
3970: ((TRANSACTION_TYPE_ID = 35) OR (TRANSACTION_SOURCE_TYPE_ID = 5 and TRANSACTION_ACTION_ID = 1))
3971: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV)
3972:
3973: OR
3974: --Account Alias Receipt
3975: ((TRANSACTION_TYPE_ID = 41) OR (TRANSACTION_SOURCE_TYPE_ID = 6 and TRANSACTION_ACTION_ID = 27))

Line 3976: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED)

3972:
3973: OR
3974: --Account Alias Receipt
3975: ((TRANSACTION_TYPE_ID = 41) OR (TRANSACTION_SOURCE_TYPE_ID = 6 and TRANSACTION_ACTION_ID = 27))
3976: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED)
3977:
3978: OR
3979: --Subinventory Transfer
3980: (

Line 3984: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED)

3980: (
3981: ((TRANSACTION_TYPE_ID = 2) OR (TRANSACTION_SOURCE_TYPE_ID = 13 and TRANSACTION_ACTION_ID = 2)) OR
3982: (TRANSACTION_SOURCE_TYPE_ID >= 100 and TRANSACTION_ACTION_ID = 2) /* 13076071 */
3983: )
3984: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED)
3985:
3986: OR
3987: --Direct Interorganization Transfer
3988: ((TRANSACTION_TYPE_ID = 3) OR (TRANSACTION_SOURCE_TYPE_ID = 13 and TRANSACTION_ACTION_ID = 3))

Line 3989: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_WIP,WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED)

3985:
3986: OR
3987: --Direct Interorganization Transfer
3988: ((TRANSACTION_TYPE_ID = 3) OR (TRANSACTION_SOURCE_TYPE_ID = 13 and TRANSACTION_ACTION_ID = 3))
3989: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_WIP,WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED)
3990:
3991: OR
3992: --Intransit Shipment
3993: ((TRANSACTION_TYPE_ID = 21) OR (TRANSACTION_SOURCE_TYPE_ID = 13 and TRANSACTION_ACTION_ID = 21))

Line 3994: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_WIP,WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED)

3990:
3991: OR
3992: --Intransit Shipment
3993: ((TRANSACTION_TYPE_ID = 21) OR (TRANSACTION_SOURCE_TYPE_ID = 13 and TRANSACTION_ACTION_ID = 21))
3994: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_WIP,WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED)
3995: OR
3996: --Average Cost Update
3997: ((TRANSACTION_TYPE_ID = 80) OR (TRANSACTION_SOURCE_TYPE_ID = 13 and TRANSACTION_ACTION_ID = 24))
3998: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_WIP,WMS_CONTAINER_PUB.LPN_CONTEXT_RCV,WMS_CONTAINER_PUB.LPN_CONTEXT_INTRANSIT,WMS_CONTAINER_PUB.LPN_PREPACK_FOR_WIP)

Line 3998: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_WIP,WMS_CONTAINER_PUB.LPN_CONTEXT_RCV,WMS_CONTAINER_PUB.LPN_CONTEXT_INTRANSIT,WMS_CONTAINER_PUB.LPN_PREPACK_FOR_WIP)

3994: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_WIP,WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED)
3995: OR
3996: --Average Cost Update
3997: ((TRANSACTION_TYPE_ID = 80) OR (TRANSACTION_SOURCE_TYPE_ID = 13 and TRANSACTION_ACTION_ID = 24))
3998: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_WIP,WMS_CONTAINER_PUB.LPN_CONTEXT_RCV,WMS_CONTAINER_PUB.LPN_CONTEXT_INTRANSIT,WMS_CONTAINER_PUB.LPN_PREPACK_FOR_WIP)
3999:
4000: OR
4001: --Sales Order Shipment
4002: ((TRANSACTION_TYPE_ID = 33) OR (TRANSACTION_SOURCE_TYPE_ID = 2 and TRANSACTION_ACTION_ID = 1))

Line 4003: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_PACKING,WMS_CONTAINER_PUB.LPN_LOADED_FOR_SHIPMENT,WMS_CONTAINER_PUB.LPN_CONTEXT_PICKED)

3999:
4000: OR
4001: --Sales Order Shipment
4002: ((TRANSACTION_TYPE_ID = 33) OR (TRANSACTION_SOURCE_TYPE_ID = 2 and TRANSACTION_ACTION_ID = 1))
4003: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_PACKING,WMS_CONTAINER_PUB.LPN_LOADED_FOR_SHIPMENT,WMS_CONTAINER_PUB.LPN_CONTEXT_PICKED)
4004:
4005: OR
4006: --Return Assemblies to WIP
4007: ((TRANSACTION_TYPE_ID = 17) OR (TRANSACTION_SOURCE_TYPE_ID = 5 and TRANSACTION_ACTION_ID = 32))

Line 4008: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED,WMS_CONTAINER_PUB.LPN_PREPACK_FOR_WIP)

4004:
4005: OR
4006: --Return Assemblies to WIP
4007: ((TRANSACTION_TYPE_ID = 17) OR (TRANSACTION_SOURCE_TYPE_ID = 5 and TRANSACTION_ACTION_ID = 32))
4008: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED,WMS_CONTAINER_PUB.LPN_PREPACK_FOR_WIP)
4009:
4010:
4011: OR
4012:

Line 4015: AND lpn_context NOT IN (WMS_CONTAINER_PUB.LPN_CONTEXT_STORES))

4011: OR
4012:
4013: -- Bug 7417173 - Container Split --bug10149138
4014: (((TRANSACTION_TYPE_ID=89) OR (TRANSACTION_SOURCE_TYPE_ID = 13 AND TRANSACTION_ACTION_ID = 52))
4015: AND lpn_context NOT IN (WMS_CONTAINER_PUB.LPN_CONTEXT_STORES))
4016:
4017: OR --Bug 10009302
4018: --Packing
4019: (((TRANSACTION_TYPE_ID = 87) OR (TRANSACTION_SOURCE_TYPE_ID = 13 and TRANSACTION_ACTION_ID = 50))

Line 4020: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED,WMS_CONTAINER_PUB.LPN_LOADED_FOR_SHIPMENT,WMS_CONTAINER_PUB.LPN_CONTEXT_PICKED))

4016:
4017: OR --Bug 10009302
4018: --Packing
4019: (((TRANSACTION_TYPE_ID = 87) OR (TRANSACTION_SOURCE_TYPE_ID = 13 and TRANSACTION_ACTION_ID = 50))
4020: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED,WMS_CONTAINER_PUB.LPN_LOADED_FOR_SHIPMENT,WMS_CONTAINER_PUB.LPN_CONTEXT_PICKED))
4021:
4022: OR --Bug 12944629
4023: --lot translate
4024: (((TRANSACTION_TYPE_ID = 84) OR (TRANSACTION_SOURCE_TYPE_ID = 13 and TRANSACTION_ACTION_ID = 42))

Line 4025: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED))

4021:
4022: OR --Bug 12944629
4023: --lot translate
4024: (((TRANSACTION_TYPE_ID = 84) OR (TRANSACTION_SOURCE_TYPE_ID = 13 and TRANSACTION_ACTION_ID = 42))
4025: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED))
4026:
4027: OR
4028:
4029: --Return Components from WIP

Line 4031: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_WIP,WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED,WMS_CONTAINER_PUB.LPN_PREPACK_FOR_WIP)--bug 10153918

4027: OR
4028:
4029: --Return Components from WIP
4030: ((TRANSACTION_TYPE_ID = 43) OR (TRANSACTION_SOURCE_TYPE_ID = 5 and TRANSACTION_ACTION_ID = 27))
4031: AND lpn_context IN (WMS_CONTAINER_PUB.LPN_CONTEXT_INV,WMS_CONTAINER_PUB.LPN_CONTEXT_WIP,WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED,WMS_CONTAINER_PUB.LPN_PREPACK_FOR_WIP)--bug 10153918
4032:
4033: )
4034: /* for bug 6903894*/
4035: