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.CN_NOTIFY_ORDERS dependencies on OE_PROFILE

Line 227: -- our call to OE_PROFILE.VALUE.

223: --+
224: -- Because this procedure is looking at orders for any
225: -- org_id, we have to get the inventory organization for
226: -- the org_id of the order, by passing that org_id into
227: -- our call to OE_PROFILE.VALUE.
228: --+
229: NVL(mtl.organization_id,NVL(oe_profile.value('OE_ORGANIZATION_ID',asoh.org_id),-99)) =
230: NVL(oe_profile.value('OE_ORGANIZATION_ID',asoh.org_id),-99)
231: AND mtl.inventory_item_id = asol.inventory_item_id

Line 229: NVL(mtl.organization_id,NVL(oe_profile.value('OE_ORGANIZATION_ID',asoh.org_id),-99)) =

225: -- org_id, we have to get the inventory organization for
226: -- the org_id of the order, by passing that org_id into
227: -- our call to OE_PROFILE.VALUE.
228: --+
229: NVL(mtl.organization_id,NVL(oe_profile.value('OE_ORGANIZATION_ID',asoh.org_id),-99)) =
230: NVL(oe_profile.value('OE_ORGANIZATION_ID',asoh.org_id),-99)
231: AND mtl.inventory_item_id = asol.inventory_item_id
232: AND mtl.invoiceable_item_flag = 'Y'); -- only want invoiceable items
233: cn_message_pkg.debug('notify: adjust: . notified');

Line 230: NVL(oe_profile.value('OE_ORGANIZATION_ID',asoh.org_id),-99)

226: -- the org_id of the order, by passing that org_id into
227: -- our call to OE_PROFILE.VALUE.
228: --+
229: NVL(mtl.organization_id,NVL(oe_profile.value('OE_ORGANIZATION_ID',asoh.org_id),-99)) =
230: NVL(oe_profile.value('OE_ORGANIZATION_ID',asoh.org_id),-99)
231: AND mtl.inventory_item_id = asol.inventory_item_id
232: AND mtl.invoiceable_item_flag = 'Y'); -- only want invoiceable items
233: cn_message_pkg.debug('notify: adjust: . notified');
234: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . notified');

Line 1297: -- organization for that org by a simple call to oe_profile.value

1293: l_rowid ROWID;
1294: --+
1295: -- Because this procedure is only looking at orders for
1296: -- the client org_id, we can get the right inventory
1297: -- organization for that org by a simple call to oe_profile.value
1298: --+
1299: l_so_org_id NUMBER;
1300: l_sys_batch_size NUMBER;
1301: l_client_org_id NUMBER;

Line 1317: l_so_org_id := NVL(oe_profile.value('OE_ORGANIZATION_ID'),-99);

1313: fnd_file.put_line(fnd_file.Log, 'notify: cn_notify_orders.regular_col_notify>>');
1314:
1315: --Added as per OM MOAC Mandate
1316: MO_GLOBAL.SET_POLICY_CONTEXT ('S', x_org_id);
1317: l_so_org_id := NVL(oe_profile.value('OE_ORGANIZATION_ID'),-99);
1318:
1319: --+
1320: -- Call Get_Notice to get any pending order updates off of the queue
1321: --+