DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_PUB dependencies on MTL_PARAMETERS

Line 2124: FROM MTL_PARAMETERS MP,

2120: decode(p_line_rec_type.TRANSACTION_ACTION_ID,2,p_line_rec_type.TRANSFER_SUBINVENTORY,28,p_line_rec_type.TRANSFER_SUBINVENTORY,null) TRANSFER_SUBINVENTORY,
2121: p_line_rec_type.TRANSFER_LOCATOR,
2122: p_line_rec_type.transaction_date,
2123: MP.NEGATIVE_INV_RECEIPT_CODE
2124: FROM MTL_PARAMETERS MP,
2125: MTL_SYSTEM_ITEMS MSI
2126: WHERE MP.ORGANIZATION_ID = p_line_rec_type.ORGANIZATION_ID
2127: -- AND MP.NEGATIVE_INV_RECEIPT_CODE = 2 'bug 3679189'
2128: AND p_line_rec_type.PROCESS_FLAG = 1

Line 2171: MTL_PARAMETERS MP,

2167: p_line_rec_type.TRANSFER_LOCATOR,
2168: p_line_rec_type.transaction_date,
2169: MP.NEGATIVE_INV_RECEIPT_CODE
2170: FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI,
2171: MTL_PARAMETERS MP,
2172: MTL_SYSTEM_ITEMS MSI
2173: WHERE MP.ORGANIZATION_ID = p_line_rec_type.ORGANIZATION_ID
2174: --AND MP.NEGATIVE_INV_RECEIPT_CODE = 2 'bug 3679189'
2175: AND MTLI.TRANSACTION_INTERFACE_ID = p_line_rec_type.TRANSACTION_INTERFACE_ID

Line 5136: FROM mtl_parameters mp, mtl_system_items msi

5132: )
5133: , p_line_rec_type.transfer_locator
5134: , p_line_rec_type.transaction_date
5135: , mp.negative_inv_receipt_code
5136: FROM mtl_parameters mp, mtl_system_items msi
5137: WHERE mp.organization_id = p_line_rec_type.organization_id
5138: -- AND MP.NEGATIVE_INV_RECEIPT_CODE = 2
5139: AND p_line_rec_type.process_flag = 1
5140: -- AND p_line_rec_type.SHIPPABLE_FLAG='Y'

Line 5180: , mtl_parameters mp

5176: , p_line_rec_type.transfer_locator
5177: , p_line_rec_type.transaction_date
5178: , mp.negative_inv_receipt_code
5179: FROM mtl_transaction_lots_interface mtli
5180: , mtl_parameters mp
5181: , mtl_system_items msi
5182: WHERE mp.organization_id = p_line_rec_type.organization_id
5183: -- AND MP.NEGATIVE_INV_RECEIPT_CODE = 2
5184: -- AND p_line_rec_type.SHIPPABLE_FLAG='Y'