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_QUANTITY_TREE_PVT dependencies on INV_MATERIAL_STATUS_GRP

Line 4679: , inv_material_status_grp.get_default_status(mmtt.organization_id

4675: and rownum = 1),5,28,mmtt.transaction_action_id),
4676: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
4677: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
4678: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
4679: , inv_material_status_grp.get_default_status(mmtt.organization_id
4680: ,mmtt.inventory_item_id
4681: ,mmtt.subinventory_code
4682: ,mmtt.locator_id
4683: ,null -- lot_number

Line 4723: , inv_material_status_grp.get_default_status(Decode(mmtt.transaction_action_id

4719: , NVL(mmtt.content_lpn_id,mmtt.transfer_lpn_id) lpn_id
4720: , to_number(NULL) transaction_action_id
4721: , to_char(NULL) transfer_subinventory_code
4722: , to_number(NULL) transfer_locator_id
4723: , inv_material_status_grp.get_default_status(Decode(mmtt.transaction_action_id
4724: , 3, mmtt.transfer_organization
4725: , mmtt.organization_id)
4726: ,mmtt.inventory_item_id
4727: ,mmtt.transfer_subinventory

Line 4732: ,inv_material_status_grp.get_default_status(mmtt.organization_id

4728: ,mmtt.transfer_to_location
4729: ,null -- lot_number
4730: ,NVL(mmtt.content_lpn_id,mmtt.transfer_lpn_id)
4731: ,mmtt.transaction_action_id
4732: ,inv_material_status_grp.get_default_status(mmtt.organization_id
4733: ,mmtt.inventory_item_id
4734: ,mmtt.subinventory_code
4735: ,mmtt.locator_id
4736: ,null -- lot_number

Line 6160: , inv_material_status_grp.get_default_status(mmtt.organization_id

6156: and rownum = 1),5,28,mmtt.transaction_action_id),
6157: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
6158: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
6159: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
6160: , inv_material_status_grp.get_default_status(mmtt.organization_id
6161: ,mmtt.inventory_item_id
6162: ,mmtt.subinventory_code
6163: ,mmtt.locator_id
6164: ,mmtt.lot_number -- lot_number

Line 6225: , inv_material_status_grp.get_default_status(mmtt.organization_id

6221: and rownum = 1),5,28,mmtt.transaction_action_id),
6222: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
6223: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
6224: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
6225: , inv_material_status_grp.get_default_status(mmtt.organization_id
6226: ,mmtt.inventory_item_id
6227: ,mmtt.subinventory_code
6228: ,mmtt.locator_id
6229: ,mtlt.lot_number -- lot_number in MTLT

Line 6269: , inv_material_status_grp.get_default_status(mmtt.organization_id

6265: , NVL(mmtt.allocated_lpn_id, NVL(mmtt.content_lpn_id, mmtt.lpn_id)) lpn_id
6266: , to_number(NULL) transaction_action_id
6267: , to_char(NULL) transfer_subinventory_code
6268: , to_number(NULL) transfer_locator_id
6269: , inv_material_status_grp.get_default_status(mmtt.organization_id
6270: ,mmtt.inventory_item_id
6271: ,mmtt.subinventory_code
6272: ,mmtt.locator_id
6273: ,NULL --lot number

Line 6309: , inv_material_status_grp.get_default_status(Decode(mmtt.transaction_action_id

6305: , NVL(mmtt.content_lpn_id,mmtt.transfer_lpn_id) lpn_id
6306: , to_number(NULL) transaction_action_id
6307: , to_char(NULL) transfer_subinventory_code
6308: , to_number(NULL) transfer_locator_id
6309: , inv_material_status_grp.get_default_status(Decode(mmtt.transaction_action_id
6310: , 3, mmtt.transfer_organization
6311: , mmtt.organization_id)
6312: ,mmtt.inventory_item_id
6313: ,mmtt.transfer_subinventory

Line 6318: ,inv_material_status_grp.get_default_status(mmtt.organization_id

6314: ,mmtt.transfer_to_location
6315: ,mmtt.lot_number -- lot_number
6316: ,NVL(mmtt.content_lpn_id,mmtt.transfer_lpn_id)
6317: ,mmtt.transaction_action_id
6318: ,inv_material_status_grp.get_default_status(mmtt.organization_id
6319: ,mmtt.inventory_item_id
6320: ,mmtt.subinventory_code
6321: ,mmtt.locator_id
6322: ,mmtt.lot_number -- lot_number

Line 6364: , inv_material_status_grp.get_default_status(Decode(mmtt.transaction_action_id

6360: , NVL(mmtt.content_lpn_id,mmtt.transfer_lpn_id) lpn_id
6361: , to_number(NULL) transaction_action_id
6362: , to_char(NULL) transfer_subinventory_code
6363: , to_number(NULL) transfer_locator_id
6364: , inv_material_status_grp.get_default_status(Decode(mmtt.transaction_action_id
6365: , 3, mmtt.transfer_organization
6366: , mmtt.organization_id)
6367: ,mmtt.inventory_item_id
6368: ,mmtt.transfer_subinventory

Line 6373: ,inv_material_status_grp.get_default_status(mmtt.organization_id

6369: ,mmtt.transfer_to_location
6370: ,mtlt.lot_number -- lot_number
6371: ,NVL(mmtt.content_lpn_id,mmtt.transfer_lpn_id)
6372: ,mmtt.transaction_action_id
6373: ,inv_material_status_grp.get_default_status(mmtt.organization_id
6374: ,mmtt.inventory_item_id
6375: ,mmtt.subinventory_code
6376: ,mmtt.locator_id
6377: ,mtlt.lot_number -- lot_number

Line 6930: , inv_material_status_grp.get_default_status(mmtt.organization_id

6926: and rownum = 1),5,28,mmtt.transaction_action_id),
6927: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
6928: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
6929: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
6930: , inv_material_status_grp.get_default_status(mmtt.organization_id
6931: ,mmtt.inventory_item_id
6932: ,mmtt.subinventory_code
6933: ,mmtt.locator_id
6934: ,mmtt.lot_number -- lot_number

Line 6992: , inv_material_status_grp.get_default_status(mmtt.organization_id

6988: and rownum = 1),5,28,mmtt.transaction_action_id),
6989: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
6990: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
6991: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
6992: , inv_material_status_grp.get_default_status(mmtt.organization_id
6993: ,mmtt.inventory_item_id
6994: ,mmtt.subinventory_code
6995: ,mmtt.locator_id
6996: ,mtlt.lot_number -- lot_number in MTLT

Line 7037: , inv_material_status_grp.get_default_status(Decode(mmtt.transaction_action_id

7033: , NVL(mmtt.content_lpn_id,mmtt.transfer_lpn_id) lpn_id
7034: , to_number(NULL) transaction_action_id
7035: , to_char(NULL) transfer_subinventory_code
7036: , to_number(NULL) transfer_locator_id
7037: , inv_material_status_grp.get_default_status(Decode(mmtt.transaction_action_id
7038: , 3, mmtt.transfer_organization
7039: , mmtt.organization_id)
7040: ,mmtt.inventory_item_id
7041: ,mmtt.transfer_subinventory

Line 7046: ,inv_material_status_grp.get_default_status(mmtt.organization_id

7042: ,mmtt.transfer_to_location
7043: ,mmtt.lot_number -- lot_number
7044: ,NVL(mmtt.content_lpn_id,mmtt.transfer_lpn_id)
7045: ,mmtt.transaction_action_id
7046: ,inv_material_status_grp.get_default_status(mmtt.organization_id
7047: ,mmtt.inventory_item_id
7048: ,mmtt.subinventory_code
7049: ,mmtt.locator_id
7050: ,mmtt.lot_number -- lot_number

Line 7092: , inv_material_status_grp.get_default_status(Decode(mmtt.transaction_action_id

7088: , NVL(mmtt.content_lpn_id,mmtt.transfer_lpn_id) lpn_id
7089: , to_number(NULL) transaction_action_id
7090: , to_char(NULL) transfer_subinventory_code
7091: , to_number(NULL) transfer_locator_id
7092: , inv_material_status_grp.get_default_status(Decode(mmtt.transaction_action_id
7093: , 3, mmtt.transfer_organization
7094: , mmtt.organization_id)
7095: ,mmtt.inventory_item_id
7096: ,mmtt.transfer_subinventory

Line 7101: ,inv_material_status_grp.get_default_status(mmtt.organization_id

7097: ,mmtt.transfer_to_location
7098: ,mtlt.lot_number -- lot_number
7099: ,NVL(mmtt.content_lpn_id,mmtt.transfer_lpn_id)
7100: ,mmtt.transaction_action_id
7101: ,inv_material_status_grp.get_default_status(mmtt.organization_id
7102: ,mmtt.inventory_item_id
7103: ,mmtt.subinventory_code
7104: ,mmtt.locator_id
7105: ,mtlt.lot_number -- lot_number