2431: sum(( NVL(line.shipped_quantity, line.ordered_quantity))
2432: * line.unit_list_price) actual_amount,
2433: adj.arithmetic_operator,
2434: adj.operand,
2435: CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL) cost,
2436: line.order_quantity_uom,
2437: head.transactional_curr_code order_currency,
2438: NVL(line.actual_shipment_date, line.request_date) trans_date
2439: FROM oe_price_adjustments adj,
2446: AND line.header_id = head.header_id
2447: group by line.inventory_item_id,
2448: adj.arithmetic_operator,
2449: adj.operand,
2450: CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL),
2451: line.order_quantity_uom,
2452: head.transactional_curr_code,
2453: NVL(line.actual_shipment_date, line.request_date);
2454: */
2462: sum(( NVL(line.shipped_quantity, line.ordered_quantity))
2463: * line.unit_list_price) actual_amount,
2464: adj.arithmetic_operator,
2465: adj.operand,
2466: --CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL) cost,
2467: line.order_quantity_uom,
2468: head.transactional_curr_code order_currency,
2469: NVL(line.actual_shipment_date, line.request_date) trans_date
2470: FROM oe_price_adjustments adj,
2477: AND line.header_id = head.header_id
2478: group by line.inventory_item_id,
2479: adj.arithmetic_operator,
2480: adj.operand,
2481: --CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL),
2482: line.order_quantity_uom,
2483: head.transactional_curr_code,
2484: NVL(line.actual_shipment_date, line.request_date);
2485:
2490: fp.product_attribute_context,
2491: fp.product_attribute,
2492: fp.product_attr_value,
2493: fc.forecast_uom_code uom,
2494: CST_COST_API.get_item_cost(1, fp.product_attr_value, l_org_id, NULL,NULL) cost,
2495: ql.arithmetic_operator,
2496: ql.operand,
2497: ao.transaction_currency_code,
2498: ao.fund_request_curr_code transaction_currency_code
4083: sum(NVL(line.shipped_quantity, line.ordered_quantity)) actual_units,
4084: sum(( NVL(line.shipped_quantity, line.ordered_quantity))* line.unit_list_price) actual_amount,
4085: adj.arithmetic_operator,
4086: adj.operand,
4087: CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL) cost,
4088: line.order_quantity_uom,
4089: head.transactional_curr_code order_currency,
4090: NVL(line.actual_shipment_date,line.request_date) trans_date
4091: FROM oe_price_adjustments adj,
4098: AND line.header_id = head.header_id
4099: GROUP BY line.inventory_item_id,
4100: adj.arithmetic_operator,
4101: adj.operand,
4102: CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL),
4103: line.order_quantity_uom,
4104: head.transactional_curr_code,
4105: NVL(line.actual_shipment_date,line.request_date);
4106:
4313: fp.product_attribute_context,
4314: fp.product_attribute,
4315: fp.product_attr_value,
4316: fc.forecast_uom_code uom,
4317: CST_COST_API.get_item_cost(1, fp.product_attr_value, l_org_id, NULL,NULL) cost,
4318: ql.arithmetic_operator,
4319: ql.operand,
4320: ao.transaction_currency_code,
4321: fc.forecast_id