ENGINATICS
SYSTEM_ADMINISTRATOR
SYSADMIN
41D6D8173E4BCF97E06362FB09051F3DY
select
*
from
dual
where
1=1
XLSX
<File Name>
<File Name>
US
Spt Material ETC / EAC Report
1=1
1
-9
:p_file_name
Char
SELECT :$FLEX$.ASSEMBLY_ITEM_NUMBER ||
' [Project: ' || :$FLEX$.PROJECT_NUMBER || ']' ||
' [Cost Type: ' || :$FLEX$.COST_TYPE_NAME || '] - ' ||
TO_CHAR(:$FLEX$.AS_OF_DATE, 'DD-MON-RR HH24:MI:SS')
FROM DUAL
US
File Name
2
-8
:p_assembly_item
Char
SELECT SEGMENT1 FROM MTL_SYSTEM_ITEMS WHERE ORGANIZATION_ID = :$FLEX$.ORGANIZATION_ID AND INVENTORY_ITEM_ID = :$FLEX$.ASSEMBLY_ITEM
US
Assembly Item Number
3
-7
:p_cost_type
Char
SELECT COST_TYPE FROM CST_COST_TYPES WHERE COST_TYPE_ID = :$FLEX$.COST_TYPE
US
Cost Type Name
4
-6
:p_project
Char
SELECT SEGMENT1 FROM PA_PROJECTS_ALL WHERE PROJECT_ID = :$FLEX$.PROJECT
US
Project Number
5
-5
:p_organization_id
Number
fnd_profile.value('MFG_ORGANIZATION_ID')
US
Organization ID
6
10
:p_compile_designator
LOV custom
Y
select distinct
mpsv.compile_designator value,
mpsv.plan_type_text||': '||mpsv.description description
from
mrp_plans_sc_v mpsv
where
nvl(mpsv.disable_date,sysdate)>=sysdate and
mpsv.data_completion_date is not null and
nvl(mpsv.plan_type,mpsv.curr_plan_type) in (1,2,3,4) and
mpsv.planned_organization in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id)
order by
mpsv.compile_designator
fnd_profile.value('MRP_DEFAULT_PLAN')
Y
US
Compile Designator
7
20
:p_assembly_item_id
LOV custom
Y
SELECT MSI.INVENTORY_ITEM_ID ID, MSI.SEGMENT1 VALUE, MSI.DESCRIPTION
FROM BOM_BILL_OF_MATERIALS BOM, MTL_SYSTEM_ITEMS MSI
WHERE BOM.ASSEMBLY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND BOM.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND BOM.ORGANIZATION_ID = :$FLEX$.ORGANIZATION_ID
ORDER BY 1
Y
US
Assembly Item
8
30
:p_project_id
LOV custom
Y
SELECT PRJ.PROJECT_ID ID, PRJ.SEGMENT1 VALUE, PRJ.NAME DESCRIPTION
FROM MRP_RECOMMENDATIONS MR, PA_PROJECTS_ALL PRJ
WHERE MR.PROJECT_ID = PRJ.PROJECT_ID
GROUP BY PRJ.SEGMENT1, PRJ.NAME, PRJ.PROJECT_ID
ORDER BY 1
Y
US
Project
9
40
:p_cost_type_id
LOV custom
Y
SELECT COST_TYPE_ID ID, COST_TYPE VALUE, DESCRIPTION DESCRIPTION
FROM CST_COST_TYPES X
WHERE ORGANIZATION_ID = :$FLEX$.ORGANIZATION_ID
AND (DISABLE_DATE IS NULL OR DISABLE_DATE >= SYSDATE)
ORDER BY COST_TYPE
Y
US
Cost Type
10
50
:p_as_of_date
DateTime
SELECT SYSDATE FROM DUAL
Y
US
As of Date