eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_AMG_GRP dependencies on OKE_DELIVERABLES_B

Line 59: Select deliverable_number from oke_deliverables_b

55: end;
56:
57: Function get_dlv_name(p_deliverable_id number) return varchar2 IS
58: cursor c_dlv_name is
59: Select deliverable_number from oke_deliverables_b
60: where deliverable_id = p_deliverable_id;
61:
62: l_name varchar2(30);
63: begin

Line 345: and et.project_id = (select project_id from oke_deliverables_b

341:
342: Cursor c_check_expend_type IS
343: Select 'x' from pa_expenditure_types_expend_v et
344: where system_linkage_function = 'VI'
345: and et.project_id = (select project_id from oke_deliverables_b
346: where deliverable_id=p_deliverable_id)
347: and expenditure_type = p_expenditure_type
348: union
349: select 'x' from pa_expenditure_types_expend_v et

Line 365: select inventory_org_id from oke_deliverables_b

361: Select 'x' from po_line_types
362: where order_type_lookup_code = 'AMOUNT'
363: and line_type_id= p_requisition_line_type_id;
364: Cursor c_get_inv_org is
365: select inventory_org_id from oke_deliverables_b
366: where deliverable_id=p_deliverable_id;
367:
368: Cursor c_check_demand_schedule IS
369: Select 'x' from mrp_designators_view v, oke_deliverables_b b

Line 369: Select 'x' from mrp_designators_view v, oke_deliverables_b b

365: select inventory_org_id from oke_deliverables_b
366: where deliverable_id=p_deliverable_id;
367:
368: Cursor c_check_demand_schedule IS
369: Select 'x' from mrp_designators_view v, oke_deliverables_b b
370: where v.designator_type = 1
371: and nvl( v.disable_date, trunc(sysdate + 1)) > trunc(sysdate)
372: and b.inventory_org_id = v.organization_id
373: and b.deliverable_id=p_deliverable_id

Line 658: from oke_deliverables_b

654: raise FND_API.G_EXC_ERROR;
655: end if;
656: l_function_currency := OKE_ACTION_VALIDATIONS_PKG.functional_currency(p_ship_to_org_id);
657: Select nvl(p_currency_code,currency_code) into l_currency
658: from oke_deliverables_b
659: where deliverable_id=p_deliverable_id;
660: p_exchange_rate := OKE_ACTION_VALIDATIONS_PKG.exchange_rate(l_currency, l_function_currency, p_exchange_rate_type,p_exchange_rate_date);
661: else
662: p_exchange_rate_date := Null;

Line 980: deliverable_id from oke_deliverables_b

976: l_row_id varchar2(30);
977:
978: CURSOR c_get_dlv_id IS
979: SELECT
980: deliverable_id from oke_deliverables_b
981: where project_id=p_dlv_rec.project_id
982: and source_deliverable_id=p_dlv_rec.pa_deliverable_id;
983:
984: cursor c_check_action(b_del_id NUMBER) IS

Line 1117: update OKE_DELIVERABLES_B

1113: X_LAST_UPDATE_LOGIN => Fnd_Global.login_id
1114: );
1115: elsif p_action=G_UPD then
1116:
1117: update OKE_DELIVERABLES_B
1118: set
1119: CURRENCY_CODE = p_dlv_rec.currency_code,
1120: UNIT_PRICE = p_dlv_rec.unit_price,
1121: UOM_CODE = p_dlv_rec.uom_code,

Line 1261: from oke_deliverable_actions act , oke_deliverables_b del

1257: cursor c_get_actions_ids(b_pa_action_id number) is
1258: Select act.action_id,
1259: act.deliverable_id,
1260: del.project_id
1261: from oke_deliverable_actions act , oke_deliverables_b del
1262: where act.deliverable_id = del.deliverable_id
1263: and pa_action_id= b_pa_action_id;
1264:
1265:

Line 1269: from oke_deliverables_b

1265:
1266: cursor c_get_del_ids(b_pa_deliverable_id number) is
1267: Select deliverable_id,
1268: project_id
1269: from oke_deliverables_b
1270: where source_deliverable_id = b_pa_deliverable_id;
1271:
1272: Cursor c_get_action_status(b_action_id number) is
1273: Select 'x' from oke_deliverable_actions

Line 1277: select inventory_org_id from oke_deliverables_b where deliverable_id=b_deliverable_id;

1273: Select 'x' from oke_deliverable_actions
1274: where action_id=b_action_id and reference1>0;
1275:
1276: Cursor c_get_inv_org(b_deliverable_id number) is
1277: select inventory_org_id from oke_deliverables_b where deliverable_id=b_deliverable_id;
1278:
1279: Cursor c_get_item_dtl(b_dlv_id number) is
1280: select uom_code,currency_code,unit_price,quantity,inventory_org_id from oke_deliverables_b
1281: where deliverable_id=b_dlv_id ;

Line 1280: select uom_code,currency_code,unit_price,quantity,inventory_org_id from oke_deliverables_b

1276: Cursor c_get_inv_org(b_deliverable_id number) is
1277: select inventory_org_id from oke_deliverables_b where deliverable_id=b_deliverable_id;
1278:
1279: Cursor c_get_item_dtl(b_dlv_id number) is
1280: select uom_code,currency_code,unit_price,quantity,inventory_org_id from oke_deliverables_b
1281: where deliverable_id=b_dlv_id ;
1282: BEGIN
1283:
1284:

Line 1610: update oke_deliverables_b set quantity = l_quantity,

1606: -- Update all columns of oke_deliverable_actions;
1607: end if;
1608: /*
1609: If p_dlv_action_type=G_REQ and p_item_dlv <> 'Y' then
1610: update oke_deliverables_b set quantity = l_quantity,
1611: unit_price = l_unit_price,
1612: currency_code = l_currency_code,
1613: uom_code = l_uom_code
1614: where deliverable_id = l_deliverable_id;

Line 1615: --Update oke_deliverables_b to update quantity, currency, uom and unit_price;

1611: unit_price = l_unit_price,
1612: currency_code = l_currency_code,
1613: uom_code = l_uom_code
1614: where deliverable_id = l_deliverable_id;
1615: --Update oke_deliverables_b to update quantity, currency, uom and unit_price;
1616: end if;
1617: */
1618: If p_dlv_action_type =G_REQ and p_dlv_req_action_rec.ready_to_procure_flag='Y' then
1619:

Line 1783: from oke_deliverable_actions act,oke_deliverables_b dlv

1779: action_name,
1780: dlv.project_id,
1781: act.quantity,
1782: act.uom_code
1783: from oke_deliverable_actions act,oke_deliverables_b dlv
1784: where pa_action_id=b_pa_action_id
1785: and dlv.deliverable_id = act.deliverable_id;
1786:
1787: l_deliverable_id Number;