DBA Data[Home] [Help]

APPS.INV_MATERIAL_STATUS_GRP dependencies on MTL_TRANSACTION_TYPES

Line 897: FROM mtl_transaction_types mtt

893: SELECT transaction_action_id,
894: transaction_source_type_id
895: INTO g_transaction_action_id,
896: g_transaction_source_type_id
897: FROM mtl_transaction_types mtt
898: WHERE mtt.transaction_type_id = p_trx_type_id;
899: g_isa_trx_type_id := p_trx_type_id;
900: ELSE
901: g_transaction_action_id := NULL;

Line 969: from mtl_transaction_types

965: if p_trx_status_enabled is null then
966: if p_trx_type_id <> nvl(g_isa_trx_type_id,-9999) THEN
967: select status_control_flag
968: into g_isa_trx_status_enabled
969: from mtl_transaction_types
970: where transaction_type_id = p_trx_type_id;
971: g_isa_trx_type_id := p_trx_type_id;
972: end if;
973: l_trx_status_enabled := g_isa_trx_status_enabled;

Line 2737: from mtl_transaction_types

2733: BEGIN
2734:
2735: select transaction_action_id
2736: into l_action_id
2737: from mtl_transaction_types
2738: where transaction_type_id = p_trx_type_id;
2739:
2740: return l_action_id;
2741: