Data Archive
- Data Archive 6.4.4
- All Products
Order | Column | Name | Data type | Required | List of Values | Security group |
---|---|---|---|---|---|---|
1 | p_cost_org_id | Cost Organization | Number | INV Organization | ||
2 | p_update_date | Update Date | Time | true | INV Accounting Period (PF-8) | Organization Unit |
List of Value Name | SQL Test Query |
---|---|
INV Organization | SELECT A.organization_name “Organization”, A.organization_code “Code”, TO_CHAR(A.organization_id) FROM ORG_ORGANIZATION_DEFINITIONS A WHERE A.inventory_enabled_flag = 'Y' ORDER BY A.organization_name, A.organization_name |
INV Accounting Period (PF-8) | SELECT A.period_name “Period Name “, T.organization_name “Organization Name”, T.organization_code “Organization Code”, A.period_name “Period Name “, T.organization_code “Organization Code”, T.organization_name “Organization Name”, TO_CHAR(A.schedule_close_date, 'DD-MON-YYYY') FROM ORG_ACCT_PERIODS A, ORG_ORGANIZATION_DEFINITIONS T WHERE A.open_flag = 'N' AND A.organization_id = T.organization_id AND T.organization_id = NVL(:params.param1,T.organization_id) |
Clause Type | Statement |
---|---|
FROM | bom.Cst_Cost_Updates C, inv.Mtl_Parameters Mp |
WHERE | C.Organization_Id =decode(:p_cost_org_id,null,c.organization_id,:p_cost_org_id) And C.Organization_Id = Mp.Organization_Id And trunc(Update_Date) <= :P_Update_Date and Mp.Primary_Cost_Method=1 |
Order | Name | Insert Statement | Delete Statement |
---|---|---|---|
1 | CST_STD_COST_ADJ_VALUES | a.cost_update_id in (select cost_update_id from XA04156_BOM1 x where x.master_org_flag = 'Y' and x.purgeable_flag = 'Y') | a.cost_update_id in (select cost_update_id from XA04156_BOM1 x where x.master_org_flag = 'Y' and x.purgeable_flag = 'Y') |
2 | CST_STANDARD_COSTS | A.cost_update_id IN (Select cost_update_id From XA04156_BOM1 x where x.purgeable_flag = 'Y') | A.cost_update_id IN (Select cost_update_id From XA04156_BOM1 x where x.purgeable_flag = 'Y') |
3 | CST_ELEMENTAL_COSTS | A.cost_update_id IN (Select cost_update_id From XA04156_BOM1 x where x.purgeable_flag = 'Y') | A.cost_update_id IN (Select cost_update_id From XA04156_BOM1 x where x.purgeable_flag = 'Y') |
4 | CST_COST_UPDATES | A.cost_update_id IN (Select cost_update_id From XA04156_BOM1 x where x.purgeable_flag = 'Y') | A.cost_update_id IN (Select cost_update_id From XA04156_BOM1 x where x.purgeable_flag = 'Y') |
Order | Name | Type | Length | PK | Select Clause |
---|---|---|---|---|---|
1 | cost_update_id | Number | true | C.Cost_Update_Id | |
2 | cost_update_date | Date | false | C.Update_Date | |
3 | org_id | Number | false | mp.Organization_Id | |
4 | master_org_flag | Char | 1 | false | decode(Mp.Organization_Id, mp.cost_organization_id,'Y','N') |
5 | purgeable_flag | Char | 1 | false | 'Y' |
6 | stats_date | Date | false |
Order | Statement Label | Literals | Group |
---|---|---|---|
1 | COST_UPDT_DT | A | Primary |