APPS.OPI_DBI_JOB_TXN_STG_PKG dependencies on OPI_DBI_JOBS_PKG

Line 2229: tmp.standard_quantity*OPI_DBI_JOBS_PKG.GET_ODM_ITEM_COST

2225: actuals.component_item_id,
2226: actuals.line_type,
2227: tmp.standard_quantity,
2228: Decode(actuals.actual_quantity, 0,
2229: tmp.standard_quantity*OPI_DBI_JOBS_PKG.GET_ODM_ITEM_COST
2230: (actuals.organization_id,
2231: actuals.component_item_id),
2232: tmp.standard_quantity*(actual_value_b/actual_quantity)),
2233: actuals.source,

Line 2434: tmp.standard_quantity*OPI_DBI_JOBS_PKG.GET_ODM_ITEM_COST

2430: actuals.component_item_id component_item_id,
2431: actuals.line_type line_type,
2432: tmp.standard_quantity standard_quantity,
2433: Decode(actuals.actual_quantity, 0,
2434: tmp.standard_quantity*OPI_DBI_JOBS_PKG.GET_ODM_ITEM_COST
2435: (actuals.organization_id,
2436: actuals.component_item_id),
2437: tmp.standard_quantity*(actual_value_b/actual_quantity))
2438: standard_value_b,

Line 2626: OPI_DBI_JOBS_PKG.GET_OPM_ITEM_COST(tmp.organization_id,

2622: tmp.item_id,
2623: actuals.line_type,
2624: sum(tmp.scaled_plan_qty*decode(actuals.line_type,2,-1,1)),
2625: sum(decode(actuals.actual_qty,0,
2626: OPI_DBI_JOBS_PKG.GET_OPM_ITEM_COST(tmp.organization_id,
2627: tmp.item_id,
2628: tmp.completion_date),
2629: actuals.actual_value_b*tmp.scaled_plan_qty/actuals.actual_qty)
2630: *decode(actuals.line_type,2,-1,1)),

Line 2741: OPI_DBI_JOBS_PKG.GET_OPM_ITEM_COST(tmp.organization_id,

2737: tmp.item_id component_item_id,
2738: actuals.line_type line_type,
2739: sum(tmp.scaled_plan_qty*decode(actuals.line_type,2,-1,1)) standard_quantity,
2740: sum(decode(actuals.actual_qty,0,
2741: OPI_DBI_JOBS_PKG.GET_OPM_ITEM_COST(tmp.organization_id,
2742: tmp.item_id,
2743: tmp.completion_date),
2744: actuals.actual_value_b*tmp.scaled_plan_qty/actuals.actual_qty)
2745: *decode(actuals.line_type,2,-1,1)) standard_value_b,