DBA Data[Home] [Help]

APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on CST_COST_API

Line 2492: CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL) cost,

2488: sum(( NVL(line.shipped_quantity, line.ordered_quantity))
2489: * line.unit_list_price) actual_amount,
2490: adj.arithmetic_operator,
2491: adj.operand,
2492: CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL) cost,
2493: line.order_quantity_uom,
2494: head.transactional_curr_code order_currency,
2495: NVL(line.actual_shipment_date, line.request_date) trans_date
2496: FROM oe_price_adjustments adj,

Line 2507: CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL),

2503: AND line.header_id = head.header_id
2504: group by line.inventory_item_id,
2505: adj.arithmetic_operator,
2506: adj.operand,
2507: CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL),
2508: line.order_quantity_uom,
2509: head.transactional_curr_code,
2510: NVL(line.actual_shipment_date, line.request_date);
2511: */

Line 2523: --CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL) cost,

2519: sum(( NVL(line.shipped_quantity, line.ordered_quantity))
2520: * line.unit_list_price) actual_amount,
2521: adj.arithmetic_operator,
2522: adj.operand,
2523: --CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL) cost,
2524: line.order_quantity_uom,
2525: head.transactional_curr_code order_currency,
2526: NVL(line.actual_shipment_date, line.request_date) trans_date
2527: FROM oe_price_adjustments adj,

Line 2538: --CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL),

2534: AND line.header_id = head.header_id
2535: group by line.inventory_item_id,
2536: adj.arithmetic_operator,
2537: adj.operand,
2538: --CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL),
2539: line.order_quantity_uom,
2540: head.transactional_curr_code,
2541: NVL(line.actual_shipment_date, line.request_date);
2542:

Line 2551: CST_COST_API.get_item_cost(1, fp.product_attr_value, l_org_id, NULL,NULL) cost,

2547: fp.product_attribute_context,
2548: fp.product_attribute,
2549: fp.product_attr_value,
2550: fc.forecast_uom_code uom,
2551: CST_COST_API.get_item_cost(1, fp.product_attr_value, l_org_id, NULL,NULL) cost,
2552: ql.arithmetic_operator,
2553: ql.operand,
2554: ao.transaction_currency_code,
2555: ao.fund_request_curr_code transaction_currency_code

Line 4150: CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL) cost,

4146: sum(NVL(line.shipped_quantity, line.ordered_quantity)) actual_units,
4147: sum(( NVL(line.shipped_quantity, line.ordered_quantity))* line.unit_list_price) actual_amount,
4148: adj.arithmetic_operator,
4149: adj.operand,
4150: CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL) cost,
4151: line.order_quantity_uom,
4152: head.transactional_curr_code order_currency,
4153: NVL(line.actual_shipment_date,line.request_date) trans_date
4154: FROM oe_price_adjustments adj,

Line 4165: CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL),

4161: AND line.header_id = head.header_id
4162: GROUP BY line.inventory_item_id,
4163: adj.arithmetic_operator,
4164: adj.operand,
4165: CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL),
4166: line.order_quantity_uom,
4167: head.transactional_curr_code,
4168: NVL(line.actual_shipment_date,line.request_date);
4169:

Line 4380: CST_COST_API.get_item_cost(1, fp.product_attr_value, l_org_id, NULL,NULL) cost,

4376: fp.product_attribute_context,
4377: fp.product_attribute,
4378: fp.product_attr_value,
4379: fc.forecast_uom_code uom,
4380: CST_COST_API.get_item_cost(1, fp.product_attr_value, l_org_id, NULL,NULL) cost,
4381: ql.arithmetic_operator,
4382: ql.operand,
4383: ao.transaction_currency_code,
4384: fc.forecast_id