DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_PUB dependencies on MTL_TRANSACTION_TYPES

Line 2763: FROM mtl_transactions_interface mti, mtl_transaction_types mtt

2759: SELECT NVL (validation_required, 1)
2760: , mtt.transaction_source_type_id, mti.wip_entity_type
2761: INTO l_valreq
2762: , l_srctypeid, l_wip_entity_type
2763: FROM mtl_transactions_interface mti, mtl_transaction_types mtt
2764: WHERE transaction_header_id = l_header_id
2765: AND mtt.transaction_type_id = mti.transaction_type_id
2766: AND ROWNUM < 2;
2767:

Line 4129: l_location_required_flag mtl_transaction_types.location_required_flag%TYPE;

4125:
4126:
4127: --Start of new code added as per the eIB TDD; Bug# 4348541
4128: DECLARE
4129: l_location_required_flag mtl_transaction_types.location_required_flag%TYPE;
4130: BEGIN
4131: l_location_required_flag := 'N';
4132: -- Call the inv_validate.check_location_required_setup procedure
4133: -- and pass l_line_rec_type.transaction_type_id as parameter to