Oracle EBS BOM equivalent query in oracle
Summary:
Hello Team,
I am researching on fining the equivalent query we are using EBS in Oracle Cloud.
SELECT
al2.organization_code,
al1.item_number,
al1.operation_seq_num,
al1.resource_code,
al1.usage_rate_or_amount,
al1.effectivity_date,
al1.disable_date,
al1.alternate_routing_designator,
al1.department_code,
substr(ora_database_name,
1,
instr(ora_database_name, '.', 1, 1) - 1),
to_char(sysdate, 'DD-Mon-YYYY HH24:MI:SS'),
'IRMFG013v01'
FROM
apps.bom_op_resources_view al1,
apps.mtl_parameters al2
WHERE
( al2.organization_id = al1.organization_id )
AND ( ( al1.effectivity_date <= sysdate
AND nvl(al1.disable_date, sysdate) >= sysdate