DBA Data[Home] [Help]

APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on MTL_TRANSACTION_REASONS

Line 625: MTL_TRANSACTION_REASONS RSN,

621: SELECT OP.operation_sequence_num, DECODE(APC.part_change_type, 'R', APC.removal_date, 'I', APC.installation_date),
622: APC.removal_code,REM.meaning,APC.removal_reason_id,RSN.reason_name,APC.removed_instance_id
623: FROM AHL_PART_CHANGES APC,
624: AHL_WORKORDER_OPERATIONS OP,
625: MTL_TRANSACTION_REASONS RSN,
626: FND_LOOKUPS REM
627: WHERE APC.part_change_id = (SELECT max(APC1.part_change_id)
628: FROM AHL_PART_CHANGES APC1,
629: AHL_WORKORDER_OPERATIONS OP1