DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_PUB dependencies on MTL_PARAMETERS

Line 2111: FROM MTL_PARAMETERS MP,

2107: 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,
2108: p_line_rec_type.TRANSFER_LOCATOR,
2109: p_line_rec_type.transaction_date,
2110: MP.NEGATIVE_INV_RECEIPT_CODE
2111: FROM MTL_PARAMETERS MP,
2112: MTL_SYSTEM_ITEMS MSI
2113: WHERE MP.ORGANIZATION_ID = p_line_rec_type.ORGANIZATION_ID
2114: -- AND MP.NEGATIVE_INV_RECEIPT_CODE = 2 'bug 3679189'
2115: AND p_line_rec_type.PROCESS_FLAG = 1

Line 2155: MTL_PARAMETERS MP,

2151: p_line_rec_type.TRANSFER_LOCATOR,
2152: p_line_rec_type.transaction_date,
2153: MP.NEGATIVE_INV_RECEIPT_CODE
2154: FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI,
2155: MTL_PARAMETERS MP,
2156: MTL_SYSTEM_ITEMS MSI
2157: WHERE MP.ORGANIZATION_ID = p_line_rec_type.ORGANIZATION_ID
2158: --AND MP.NEGATIVE_INV_RECEIPT_CODE = 2 'bug 3679189'
2159: AND MTLI.TRANSACTION_INTERFACE_ID = p_line_rec_type.TRANSACTION_INTERFACE_ID

Line 4995: FROM mtl_parameters mp, mtl_system_items msi

4991: )
4992: , p_line_rec_type.transfer_locator
4993: , p_line_rec_type.transaction_date
4994: , mp.negative_inv_receipt_code
4995: FROM mtl_parameters mp, mtl_system_items msi
4996: WHERE mp.organization_id = p_line_rec_type.organization_id
4997: -- AND MP.NEGATIVE_INV_RECEIPT_CODE = 2
4998: AND p_line_rec_type.process_flag = 1
4999: -- AND p_line_rec_type.SHIPPABLE_FLAG='Y'

Line 5039: , mtl_parameters mp

5035: , p_line_rec_type.transfer_locator
5036: , p_line_rec_type.transaction_date
5037: , mp.negative_inv_receipt_code
5038: FROM mtl_transaction_lots_interface mtli
5039: , mtl_parameters mp
5040: , mtl_system_items msi
5041: WHERE mp.organization_id = p_line_rec_type.organization_id
5042: -- AND MP.NEGATIVE_INV_RECEIPT_CODE = 2
5043: -- AND p_line_rec_type.SHIPPABLE_FLAG='Y'