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 5466: , inv_material_status_grp.get_default_status(mmtt.organization_id

5462: NVL(mmtt.content_lpn_id, mmtt.lpn_id)) lpn_id
5463: , Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id, to_number(NULL)) transaction_action_id
5464: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
5465: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
5466: , inv_material_status_grp.get_default_status(mmtt.organization_id
5467: ,mmtt.inventory_item_id
5468: ,mmtt.subinventory_code
5469: ,mmtt.locator_id
5470: ,null -- lot_number

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

5504: , NVL(mmtt.content_lpn_id,mmtt.transfer_lpn_id) lpn_id
5505: , to_number(NULL) transaction_action_id
5506: , to_char(NULL) transfer_subinventory_code
5507: , to_number(NULL) transfer_locator_id
5508: , inv_material_status_grp.get_default_status(Decode(mmtt.transaction_action_id
5509: , 3, mmtt.transfer_organization
5510: , mmtt.organization_id)
5511: ,mmtt.inventory_item_id
5512: ,mmtt.transfer_subinventory

Line 5517: ,inv_material_status_grp.get_default_status(mmtt.organization_id

5513: ,mmtt.transfer_to_location
5514: ,null -- lot_number
5515: ,NVL(mmtt.content_lpn_id,mmtt.transfer_lpn_id)
5516: ,mmtt.transaction_action_id
5517: ,inv_material_status_grp.get_default_status(mmtt.organization_id
5518: ,mmtt.inventory_item_id
5519: ,mmtt.subinventory_code
5520: ,mmtt.locator_id
5521: ,null -- lot_number

Line 6024: , inv_material_status_grp.get_default_status(mmtt.organization_id

6020: NVL(mmtt.content_lpn_id, mmtt.lpn_id)) lpn_id
6021: , Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id, to_number(NULL)) transaction_action_id
6022: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
6023: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
6024: , inv_material_status_grp.get_default_status(mmtt.organization_id
6025: ,mmtt.inventory_item_id
6026: ,mmtt.subinventory_code
6027: ,mmtt.locator_id
6028: ,mmtt.lot_number -- lot_number

Line 6077: , inv_material_status_grp.get_default_status(mmtt.organization_id

6073: NVL(mmtt.content_lpn_id, mmtt.lpn_id)) lpn_id
6074: , Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id, to_number(NULL)) transaction_action_id
6075: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
6076: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
6077: , inv_material_status_grp.get_default_status(mmtt.organization_id
6078: ,mmtt.inventory_item_id
6079: ,mmtt.subinventory_code
6080: ,mmtt.locator_id
6081: ,mtlt.lot_number -- lot_number in MTLT

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

6116: , NVL(mmtt.content_lpn_id,mmtt.transfer_lpn_id) lpn_id
6117: , to_number(NULL) transaction_action_id
6118: , to_char(NULL) transfer_subinventory_code
6119: , to_number(NULL) transfer_locator_id
6120: , inv_material_status_grp.get_default_status(Decode(mmtt.transaction_action_id
6121: , 3, mmtt.transfer_organization
6122: , mmtt.organization_id)
6123: ,mmtt.inventory_item_id
6124: ,mmtt.transfer_subinventory

Line 6129: ,inv_material_status_grp.get_default_status(mmtt.organization_id

6125: ,mmtt.transfer_to_location
6126: ,mmtt.lot_number -- lot_number
6127: ,NVL(mmtt.content_lpn_id,mmtt.transfer_lpn_id)
6128: ,mmtt.transaction_action_id
6129: ,inv_material_status_grp.get_default_status(mmtt.organization_id
6130: ,mmtt.inventory_item_id
6131: ,mmtt.subinventory_code
6132: ,mmtt.locator_id
6133: ,mmtt.lot_number -- lot_number

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

6163: , NVL(mmtt.content_lpn_id,mmtt.transfer_lpn_id) lpn_id
6164: , to_number(NULL) transaction_action_id
6165: , to_char(NULL) transfer_subinventory_code
6166: , to_number(NULL) transfer_locator_id
6167: , inv_material_status_grp.get_default_status(Decode(mmtt.transaction_action_id
6168: , 3, mmtt.transfer_organization
6169: , mmtt.organization_id)
6170: ,mmtt.inventory_item_id
6171: ,mmtt.transfer_subinventory

Line 6176: ,inv_material_status_grp.get_default_status(mmtt.organization_id

6172: ,mmtt.transfer_to_location
6173: ,mtlt.lot_number -- lot_number
6174: ,NVL(mmtt.content_lpn_id,mmtt.transfer_lpn_id)
6175: ,mmtt.transaction_action_id
6176: ,inv_material_status_grp.get_default_status(mmtt.organization_id
6177: ,mmtt.inventory_item_id
6178: ,mmtt.subinventory_code
6179: ,mmtt.locator_id
6180: ,mtlt.lot_number -- lot_number

Line 6681: , inv_material_status_grp.get_default_status(mmtt.organization_id

6677: NVL(mmtt.content_lpn_id, mmtt.lpn_id)) lpn_id
6678: , Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id, to_number(NULL)) transaction_action_id
6679: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
6680: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
6681: , inv_material_status_grp.get_default_status(mmtt.organization_id
6682: ,mmtt.inventory_item_id
6683: ,mmtt.subinventory_code
6684: ,mmtt.locator_id
6685: ,mmtt.lot_number -- lot_number

Line 6732: , inv_material_status_grp.get_default_status(mmtt.organization_id

6728: NVL(mmtt.content_lpn_id, mmtt.lpn_id)) lpn_id
6729: , Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id, to_number(NULL)) transaction_action_id
6730: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
6731: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
6732: , inv_material_status_grp.get_default_status(mmtt.organization_id
6733: ,mmtt.inventory_item_id
6734: ,mmtt.subinventory_code
6735: ,mmtt.locator_id
6736: ,mtlt.lot_number -- lot_number in MTLT

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

6771: , NVL(mmtt.content_lpn_id,mmtt.transfer_lpn_id) lpn_id
6772: , to_number(NULL) transaction_action_id
6773: , to_char(NULL) transfer_subinventory_code
6774: , to_number(NULL) transfer_locator_id
6775: , inv_material_status_grp.get_default_status(Decode(mmtt.transaction_action_id
6776: , 3, mmtt.transfer_organization
6777: , mmtt.organization_id)
6778: ,mmtt.inventory_item_id
6779: ,mmtt.transfer_subinventory

Line 6784: ,inv_material_status_grp.get_default_status(mmtt.organization_id

6780: ,mmtt.transfer_to_location
6781: ,mmtt.lot_number -- lot_number
6782: ,NVL(mmtt.content_lpn_id,mmtt.transfer_lpn_id)
6783: ,mmtt.transaction_action_id
6784: ,inv_material_status_grp.get_default_status(mmtt.organization_id
6785: ,mmtt.inventory_item_id
6786: ,mmtt.subinventory_code
6787: ,mmtt.locator_id
6788: ,mmtt.lot_number -- lot_number

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

6818: , NVL(mmtt.content_lpn_id,mmtt.transfer_lpn_id) lpn_id
6819: , to_number(NULL) transaction_action_id
6820: , to_char(NULL) transfer_subinventory_code
6821: , to_number(NULL) transfer_locator_id
6822: , inv_material_status_grp.get_default_status(Decode(mmtt.transaction_action_id
6823: , 3, mmtt.transfer_organization
6824: , mmtt.organization_id)
6825: ,mmtt.inventory_item_id
6826: ,mmtt.transfer_subinventory

Line 6831: ,inv_material_status_grp.get_default_status(mmtt.organization_id

6827: ,mmtt.transfer_to_location
6828: ,mtlt.lot_number -- lot_number
6829: ,NVL(mmtt.content_lpn_id,mmtt.transfer_lpn_id)
6830: ,mmtt.transaction_action_id
6831: ,inv_material_status_grp.get_default_status(mmtt.organization_id
6832: ,mmtt.inventory_item_id
6833: ,mmtt.subinventory_code
6834: ,mmtt.locator_id
6835: ,mtlt.lot_number -- lot_number