APPS.INV_TURNS dependencies on MTL_PARAMETERS

Line 1003: mtl_parameters mp

999: oap.period_start_date,
1000: oap.schedule_close_date,
1001: mp.primary_cost_method
1002: FROM org_acct_periods oap,
1003: mtl_parameters mp
1004: WHERE oap.organization_id = mp.organization_id
1005: AND ( oap.organization_id, oap.acct_period_id)
1006: IN
1007: (SELECT oap.organization_id, oap.acct_period_id

Line 1026: mtl_parameters mp

1022: oap.period_start_date,
1023: oap.schedule_close_date,
1024: mp.primary_cost_method
1025: FROM org_acct_periods oap,
1026: mtl_parameters mp
1027: WHERE oap.organization_id = mp.organization_id
1028: AND oap.open_flag = 'N'
1029: AND oap.schedule_close_date <= INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Sysdate,oap.organization_id)
1030: AND mp.process_enabled_flag <> 'Y' -- Added for R12 uptake. Ignore all data in process orgs.

Line 1100: FROM ORG_ACCT_PERIODS oap, mtl_parameters mp

1096:
1097: CURSOR OPEN_PERS IS
1098: SELECT oap.organization_id, oap.acct_period_id, oap.period_start_date,
1099: oap.schedule_close_date
1100: FROM ORG_ACCT_PERIODS oap, mtl_parameters mp
1101: WHERE oap.open_flag = 'Y'
1102: AND oap.organization_id = mp.organization_id
1103: AND mp.process_enabled_flag <> 'Y' -- Added for R12 uptake. Ignore all data in process orgs.
1104: AND INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Sysdate,oap.organization_id) >= period_start_date

Line 1115: mtl_parameters mp

1111: CURSOR OPEN_ONHAND IS
1112: SELECT cql.inventory_item_id,
1113: ROUND(SUM(NVL((cql.layer_quantity * cql.item_cost),0)),2) onhand
1114: FROM cst_quantity_layers cql,
1115: mtl_parameters mp
1116: WHERE cql.organization_id = l_organization_id
1117: AND cql.organization_id = mp.organization_id
1118: AND mp.primary_cost_method IN (2,5,6)
1119: GROUP BY cql.inventory_item_id

Line 1124: mtl_parameters mp

1120: UNION ALL
1121: SELECT moq.inventory_item_id,
1122: ROUND(SUM(NVL((moq.transaction_quantity * moq.item_cost),0)),2) onhand
1123: FROM mtl_onhand_qty_cost_v moq,
1124: mtl_parameters mp
1125: WHERE moq.organization_id = l_organization_id
1126: AND moq.organization_id = mp.organization_id
1127: AND mp.primary_cost_method = 1
1128: GROUP BY inventory_item_id;

Line 1143: FROM MTL_PARAMETERS MP1,

1139: ROUND(SUM(NVL(DECODE(CIVV.intransit_owning_org_id,
1140: CIVV.from_organization_id, CIVV.quantity,
1141: CIVV.to_organization_id,
1142: CIVV.to_org_primary_quantity) * CST.item_cost, 0)),2) it_sum
1143: FROM MTL_PARAMETERS MP1,
1144: MTL_PARAMETERS MP2,
1145: CST_CG_ITEM_COSTS_VIEW CST,
1146: CST_INTRANSIT_VALUE_VIEW CIVV
1147: WHERE CIVV.intransit_owning_org_id = l_organization_id

Line 1144: MTL_PARAMETERS MP2,

1140: CIVV.from_organization_id, CIVV.quantity,
1141: CIVV.to_organization_id,
1142: CIVV.to_org_primary_quantity) * CST.item_cost, 0)),2) it_sum
1143: FROM MTL_PARAMETERS MP1,
1144: MTL_PARAMETERS MP2,
1145: CST_CG_ITEM_COSTS_VIEW CST,
1146: CST_INTRANSIT_VALUE_VIEW CIVV
1147: WHERE CIVV.intransit_owning_org_id = l_organization_id
1148: AND MP1.organization_id = CIVV.from_organization_id