DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_PUB dependencies on MTL_TRANSACTION_TYPES

Line 2719: FROM mtl_transactions_interface mti, mtl_transaction_types mtt

2715: SELECT NVL (validation_required, 1)
2716: , mtt.transaction_source_type_id, mti.wip_entity_type
2717: INTO l_valreq
2718: , l_srctypeid, l_wip_entity_type
2719: FROM mtl_transactions_interface mti, mtl_transaction_types mtt
2720: WHERE transaction_header_id = l_header_id
2721: AND mtt.transaction_type_id = mti.transaction_type_id
2722: AND ROWNUM < 2;
2723:

Line 4007: l_location_required_flag mtl_transaction_types.location_required_flag%TYPE;

4003:
4004:
4005: --Start of new code added as per the eIB TDD; Bug# 4348541
4006: DECLARE
4007: l_location_required_flag mtl_transaction_types.location_required_flag%TYPE;
4008: BEGIN
4009: l_location_required_flag := 'N';
4010: -- Call the inv_validate.check_location_required_setup procedure
4011: -- and pass l_line_rec_type.transaction_type_id as parameter to