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.CTO_CHANGE_ORDER_PK dependencies on FND_USER

Line 400: lplanner_code fnd_user.user_name%type; -- Modified by Renga on 11/24/04

396: i binary_integer;
397: lconfig_id oe_order_lines.configuration_id%type;
398: lorder_no oe_order_headers_all.order_number%type;
399: lheader_id oe_order_headers_all.header_id%type;
400: lplanner_code fnd_user.user_name%type; -- Modified by Renga on 11/24/04
401: --for bug 4026568
402: lOrg_id mtl_system_items.organization_id%type;
403: lStmtNumber number;
404: lResv_exists boolean;

Line 454: l_user_name fnd_user.user_name%type; -- Added for bug 14065108

450: l_message varchar2(100);
451:
452: -- Bug fix 4863275
453: l_shipping_xfaced_flag varchar2(1);
454: l_user_name fnd_user.user_name%type; -- Added for bug 14065108
455:
456: BEGIN
457:
458: X_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1360: lplanner_code fnd_user.user_name%type; -- Modified by Renga on

1356: lcust_line_no varchar2(50);
1357: lnotify_person varchar2(200);
1358: i binary_integer;
1359: linv_item_id oe_order_lines_all.inventory_item_id%type;
1360: lplanner_code fnd_user.user_name%type; -- Modified by Renga on
1361: --11/24/04 for bug 4026568
1362: lship_org_id oe_order_lines_all.ship_from_org_id%type;
1363: ldummy varchar2(1);
1364: lstmt number;

Line 1418: FND_USER FU

1414: CURSOR get_buyer_user_name(inv_item_id NUMBER,ship_org_id NUMBER) IS
1415: SELECT FU.user_name
1416: FROM MTL_SYSTEM_ITEMS MTI,
1417: PO_BUYERS_ALL_V PBAV,
1418: FND_USER FU
1419: WHERE MTI.inventory_item_id = inv_item_id
1420: AND MTI.organization_id = ship_org_id
1421: AND MTI.buyer_id = PBAV.employee_id
1422: AND PBAV.employee_id = FU.employee_id(+) --outer join b'cos employee need not be an fnd user.

Line 1422: AND PBAV.employee_id = FU.employee_id(+) --outer join b'cos employee need not be an fnd user.

1418: FND_USER FU
1419: WHERE MTI.inventory_item_id = inv_item_id
1420: AND MTI.organization_id = ship_org_id
1421: AND MTI.buyer_id = PBAV.employee_id
1422: AND PBAV.employee_id = FU.employee_id(+) --outer join b'cos employee need not be an fnd user.
1423: ORDER BY FU.user_name asc;
1424:
1425: -- bug 7447357.pdube Tue Oct 21 04:31:34 PDT 2008
1426: -- Introdcued this to get a unique user name

Line 1431: fnd_user u

1427: CURSOR get_planner_user_name(inv_item_id NUMBER,ship_org_id NUMBER) IS
1428: SELECT u.user_name
1429: FROM mtl_system_items_vl item,
1430: mtl_planners p,
1431: fnd_user u
1432: WHERE item.inventory_item_id = inv_item_id
1433: and item.organization_id = ship_org_id
1434: and p.organization_id = item.organization_id
1435: and p.planner_code = item.planner_code

Line 1447: fnd_user u

1443: select u.user_name
1444: from mtl_reservations mr,
1445: po_headers_all poh,
1446: oe_order_lines_all oel,
1447: fnd_user u
1448: where oel.line_id = config_line_id and
1449: mr.demand_source_type_id in (8,2) and
1450: mr.demand_source_line_id = oel.line_id and
1451: mr.supply_source_type_id = 1 and

Line 1465: fnd_user u

1461: from mtl_reservations mr,
1462: po_requisition_headers_all porh,
1463: po_requisition_lines_all porl,
1464: oe_order_lines_all oel,
1465: fnd_user u
1466: where oel.line_id = config_line_id and
1467: mr.demand_source_type_id in (8,2) and
1468: mr.demand_source_line_id = oel.line_id and
1469: mr.supply_source_type_id = 17 and

Line 1780: FND_USER U

1776: /*SELECT u.user_name
1777: INTO lplanner_code
1778: FROM MTL_SYSTEM_ITEMS A,
1779: PO_BUYERS_ALL_V B,
1780: FND_USER U
1781: WHERE a.inventory_item_id = linv_item_id
1782: AND a.organization_id = lship_org_id
1783: AND a.buyer_id = b.employee_id
1784: AND b.employee_id = u.employee_id(+); --outer join b'cos employee need not be an fnd user.*/

Line 1784: AND b.employee_id = u.employee_id(+); --outer join b'cos employee need not be an fnd user.*/

1780: FND_USER U
1781: WHERE a.inventory_item_id = linv_item_id
1782: AND a.organization_id = lship_org_id
1783: AND a.buyer_id = b.employee_id
1784: AND b.employee_id = u.employee_id(+); --outer join b'cos employee need not be an fnd user.*/
1785:
1786: -- bug 7447357.ntungare
1787: -- Get the Config Item line id
1788: -- bug 13720792. Moved it outside

Line 1852: ,fnd_user u

1848: /*SELECT u.user_name
1849: INTO lplanner_code
1850: FROM mtl_system_items_vl item
1851: ,mtl_planners p
1852: ,fnd_user u
1853: WHERE item.inventory_item_id = linv_item_id
1854: and item.organization_id = lship_org_id
1855: and p.organization_id = item.organization_id
1856: and p.planner_code = item.planner_code

Line 1857: and p.employee_id = u.employee_id(+); --outer join b'cos employee need not be an fnd user.*/

1853: WHERE item.inventory_item_id = linv_item_id
1854: and item.organization_id = lship_org_id
1855: and p.organization_id = item.organization_id
1856: and p.planner_code = item.planner_code
1857: and p.employee_id = u.employee_id(+); --outer join b'cos employee need not be an fnd user.*/
1858: OPEN get_planner_user_name(linv_item_id,lship_org_id);
1859: FETCH get_planner_user_name into lplanner_code;
1860: CLOSE get_planner_user_name;
1861:

Line 3273: return fnd_user.user_name%type

3269: pline_no in number ,
3270: xErrorMessage out NOCOPY varchar2 ,
3271: xMessageName out NOCOPY varchar2 ,
3272: xTableName out NOCOPY varchar2 )
3273: return fnd_user.user_name%type
3274: IS
3275:
3276: lStmtNumber number;
3277: linv_item_id oe_order_lines_all.inventory_item_id%type;

Line 3283: lplanner_code fnd_user.user_name%type;

3279: l_header_id oe_order_lines_all.header_id%type;
3280:
3281:
3282: l_config_line_id number;
3283: lplanner_code fnd_user.user_name%type;
3284:
3285: -- Cursor to get a unique user name based on the Buyer on the PO
3286: CURSOR get_buyer_from_po(config_line_id IN NUMBER) IS
3287: select u.user_name

Line 3291: fnd_user u

3287: select u.user_name
3288: from mtl_reservations mr,
3289: po_headers_all poh,
3290: oe_order_lines_all oel,
3291: fnd_user u
3292: where oel.line_id = config_line_id and
3293: mr.demand_source_type_id in (8,2) and
3294: mr.demand_source_line_id = oel.line_id and
3295: mr.supply_source_type_id = 1 and

Line 3307: fnd_user u

3303: from mtl_reservations mr,
3304: po_requisition_headers_all porh,
3305: po_requisition_lines_all porl,
3306: oe_order_lines_all oel,
3307: fnd_user u
3308: where oel.line_id = config_line_id and
3309: mr.demand_source_type_id in (8,2) and
3310: mr.demand_source_line_id = oel.line_id and
3311: mr.supply_source_type_id = 17 and

Line 3323: FND_USER FU

3319: CURSOR get_buyer_user_name(inv_item_id NUMBER,ship_org_id NUMBER) IS
3320: SELECT FU.user_name
3321: FROM MTL_SYSTEM_ITEMS MTI,
3322: PO_BUYERS_ALL_V PBAV,
3323: FND_USER FU
3324: WHERE MTI.inventory_item_id = inv_item_id
3325: AND MTI.organization_id = ship_org_id
3326: AND MTI.buyer_id = PBAV.employee_id
3327: AND PBAV.employee_id = FU.employee_id(+) --outer join b'cos employee need not be an fnd user.

Line 3327: AND PBAV.employee_id = FU.employee_id(+) --outer join b'cos employee need not be an fnd user.

3323: FND_USER FU
3324: WHERE MTI.inventory_item_id = inv_item_id
3325: AND MTI.organization_id = ship_org_id
3326: AND MTI.buyer_id = PBAV.employee_id
3327: AND PBAV.employee_id = FU.employee_id(+) --outer join b'cos employee need not be an fnd user.
3328: ORDER BY FU.user_name asc;
3329:
3330: BEGIN
3331: