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 MTL_SYSTEM_ITEMS

Line 402: lOrg_id mtl_system_items.organization_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;
405: lato_item_flag varchar2(1) := 'N';
406:

Line 723: from mtl_system_items msi

719: -- If the item is non atpable then scheduling will not catch. So we are validating here
720:
721: select option_specific_sourced
722: into l_option_specific
723: from mtl_system_items msi
724: where msi.inventory_item_id = lconfig_id
725: and rownum = 1;
726:
727: If l_option_specific is not null Then

Line 1350: litem_name mtl_system_items_kfv.concatenated_segments%type; --OPM

1346:
1347: litem_key varchar2(100);
1348: luser_key varchar2(100);
1349: lcustomer_name varchar2(400);
1350: litem_name mtl_system_items_kfv.concatenated_segments%type; --OPM
1351: lreq_date date;
1352: lssd_date date;
1353: lsad_date date;
1354: lord_qty number;

Line 1416: FROM MTL_SYSTEM_ITEMS MTI,

1412: -- bug 7447357.pdube Mon Oct 20 04:03:59 PDT 2008
1413: -- Introdcued this to get a unique user name
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

Line 1429: FROM mtl_system_items_vl item,

1425: -- bug 7447357.pdube Tue Oct 21 04:31:34 PDT 2008
1426: -- Introdcued this to get a unique user name
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

Line 1519: mtl_system_items msi,

1515: wfs.schedule_number job_number,
1516: NULL line_number
1517: FROM wip_flow_schedules wfs,
1518: oe_order_lines_all oel,
1519: mtl_system_items msi,
1520: mfg_lookups mlk,
1521: mfg_lookups mlk2
1522: WHERE wfs.demand_source_line = p_line_id
1523: AND oel.line_id = p_line_id

Line 1707: FROM mtl_system_items_kfv

1703:
1704: lstmt := 25; --OPM
1705: SELECT concatenated_segments
1706: INTO litem_name
1707: FROM mtl_system_items_kfv
1708: WHERE inventory_item_id = pconfig_id
1709: AND organization_id = lship_org_id;
1710:
1711: -- Get the customer name from ra_customers_view

Line 1762: -- Buyer . Get the buyer info from Mtl_system_items

1758: end if;
1759:
1760:
1761: -- In the case of Buy ATo item we need to send the notification to the
1762: -- Buyer . Get the buyer info from Mtl_system_items
1763: IF pmlmo_flag = 'B' THEN
1764:
1765: IF PG_DEBUG <> 0 THEN
1766: oe_debug_pub.add('start_work_flow: ' || 'Getting buyer info..',1);

Line 1778: FROM MTL_SYSTEM_ITEMS A,

1774: -- Bug 7447357.pdube Mon Oct 20 04:26:25 PDT 2008.
1775: -- getting the value for user_name in the variable.
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

Line 1850: FROM mtl_system_items_vl item

1846: -- Bug 7447357.pdube Tue Oct 21 04:31:34 PDT 2008.
1847: -- getting the value for user_name in the variable.
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

Line 2432: pInventory_item_id IN mtl_system_items.inventory_item_id%type,

2428:
2429:
2430:
2431: PROCEDURE Is_item_ML_OR_MO(
2432: pInventory_item_id IN mtl_system_items.inventory_item_id%type,
2433: pOrg_id IN mtl_system_items.organization_id%type,
2434: x_result OUT NOCOPY Varchar2,
2435: x_source_type OUT NOCOPY Number,
2436: x_return_status OUT NOCOPY Varchar2,

Line 2433: pOrg_id IN mtl_system_items.organization_id%type,

2429:
2430:
2431: PROCEDURE Is_item_ML_OR_MO(
2432: pInventory_item_id IN mtl_system_items.inventory_item_id%type,
2433: pOrg_id IN mtl_system_items.organization_id%type,
2434: x_result OUT NOCOPY Varchar2,
2435: x_source_type OUT NOCOPY Number,
2436: x_return_status OUT NOCOPY Varchar2,
2437: x_msg_count OUT NOCOPY Number,

Line 2533: MTL_SYSTEM_ITEMS MTL

2529: SELECT 'Y'
2530: INTO x_result
2531: FROM BOM_BILL_OF_MATERIALS BOM,
2532: BOM_INVENTORY_COMPONENTS BIC,
2533: MTL_SYSTEM_ITEMS MTL
2534: WHERE BOM.Assembly_item_id = pInventory_item_id
2535: AND BOM.Organization_id = pOrg_id
2536: AND BOM.Bill_sequence_id = BIC.Bill_sequence_id
2537: AND BIC.Bom_item_type = 4 --- Standard item

Line 3321: FROM MTL_SYSTEM_ITEMS MTI,

3317:
3318: --
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