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_BOM_RTG_PK dependencies on MTL_SYSTEM_ITEMS

Line 491: lplanner_code mtl_system_items_vl.planner_code%type;

487: v_problem_model_line_num varchar2(1000) ;
488: v_table_count number ;
489: v_error_org varchar2(1000) ;
490: v_recipient varchar2(100) ;
491: lplanner_code mtl_system_items_vl.planner_code%type;
492:
493: BEGIN
494:
495: xReturnStatus := fnd_api.g_ret_sts_success;

Line 772: from mtl_system_items msi,

768: If ( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
769: select (ceil(nvl(msi.fixed_lead_time,0)
770: + nvl(msi.variable_lead_time,0) * bcol.ordered_quantity))
771: into lLeadTime
772: from mtl_system_items msi,
773: bom_cto_order_lines bcol
774: where bcol.line_id = pLineId
775: and msi.inventory_item_id = bcol.inventory_item_id
776: and msi.organization_id = CTO_UTILITY_PK.PC_BOM_VALIDATION_ORG;

Line 782: from mtl_system_items msi,

778: else
779: select (ceil(nvl(msi.fixed_lead_time,0)
780: + nvl(msi.variable_lead_time,0) * oel.ordered_quantity))
781: into lLeadTime
782: from mtl_system_items msi,
783: oe_order_lines_all oel
784: where oel.line_id = pLineId
785: and msi.inventory_item_id = oel.inventory_item_id
786: and msi.organization_id = oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id);

Line 804: mtl_system_items msi,

800: begin
801: select CAL.CALENDAR_DATE
802: into lEstRelDate
803: from bom_calendar_dates cal,
804: mtl_system_items msi,
805: bom_cto_order_lines bcol,
806: mtl_parameters mp
807: where msi.organization_id = lNextRec.organization_id
808: and msi.inventory_item_id = pModelId

Line 870: from mtl_system_items_kfv msi,

866: -1
867: into v_missed_item,
868: v_missed_line_number,
869: v_order_number
870: from mtl_system_items_kfv msi,
871: bom_cto_order_lines bcol
872: where msi.organization_id = bcol.ship_from_org_id
873: and msi.inventory_item_id = bcol.inventory_item_id
874: and bcol.parent_ato_line_id = pLineId

Line 891: from mtl_system_items_kfv msi,

887: oeh.order_number
888: into v_missed_item,
889: v_missed_line_number,
890: v_order_number
891: from mtl_system_items_kfv msi,
892: oe_order_lines_all oel,
893: oe_order_headers_all oeh
894: ,bom_cto_order_lines bcol
895: where msi.organization_id = oel.ship_from_org_id

Line 930: from mtl_system_items_kfv

926: END IF;
927:
928: select substrb(concatenated_segments,1,50)
929: into l_model
930: from mtl_system_items_kfv
931: where organization_id = lNextRec.organization_id
932: and inventory_item_id = pModelId ;
933:
934:

Line 1080: from mtl_system_items

1076: lxMessageName := 'CTO_DROP_ITEM_FROM_CONFIG';
1077:
1078: select segment1
1079: into v_problem_model
1080: from mtl_system_items
1081: where inventory_item_id = pModelId
1082: and rownum = 1 ;
1083:
1084: select segment1

Line 1086: from mtl_system_items

1082: and rownum = 1 ;
1083:
1084: select segment1
1085: into v_problem_config
1086: from mtl_system_items
1087: where inventory_item_id = pConfigId
1088: and rownum = 1 ;
1089:
1090: select organization_name

Line 1129: from mtl_system_items

1125: lxMessageName := 'CTO_DO_NOT_CREATE_ITEM';
1126:
1127: select segment1
1128: into v_problem_model
1129: from mtl_system_items
1130: where inventory_item_id = pModelId
1131: and rownum = 1 ;
1132:
1133: select segment1

Line 1135: from mtl_system_items

1131: and rownum = 1 ;
1132:
1133: select segment1
1134: into v_problem_config
1135: from mtl_system_items
1136: where inventory_item_id = pConfigId
1137: and rownum = 1 ;
1138:
1139: select organization_name

Line 1191: from mtl_system_items

1187:
1188: CTO_CONFIG_BOM_PK.gApplyHold := 'Y';
1189: select segment1
1190: into v_problem_model
1191: from mtl_system_items
1192: where inventory_item_id = pModelId
1193: and rownum = 1 ;
1194:
1195: select segment1

Line 1197: from mtl_system_items

1193: and rownum = 1 ;
1194:
1195: select segment1
1196: into v_problem_config
1197: from mtl_system_items
1198: where inventory_item_id = pConfigId
1199: and rownum = 1 ;
1200:
1201: select organization_name

Line 1271: FROM mtl_system_items_vl item

1267:
1268: BEGIN
1269: SELECT u.user_name
1270: INTO lplanner_code
1271: FROM mtl_system_items_vl item
1272: ,mtl_planners p
1273: ,fnd_user u
1274: WHERE item.inventory_item_id = pModelId
1275: and item.organization_id = lNextRec.organization_id

Line 1314: from mtl_system_items

1310: oe_debug_pub.add ('Not creating Item...');
1311: END IF;
1312: select segment1
1313: into v_problem_model
1314: from mtl_system_items
1315: where inventory_item_id = pModelId
1316: and rownum = 1 ;
1317:
1318: select segment1

Line 1320: from mtl_system_items

1316: and rownum = 1 ;
1317:
1318: select segment1
1319: into v_problem_config
1320: from mtl_system_items
1321: where inventory_item_id = pConfigId
1322: and rownum = 1 ;
1323: select organization_name
1324: into v_error_org

Line 1384: FROM mtl_system_items_vl item

1380:
1381: BEGIN
1382: SELECT u.user_name
1383: INTO lplanner_code
1384: FROM mtl_system_items_vl item
1385: ,mtl_planners p
1386: ,fnd_user u
1387: WHERE item.inventory_item_id = pModelId
1388: and item.organization_id = lNextRec.organization_id

Line 1691: from mtl_system_items_kfv

1687:
1688: if( v_bom_created = 0 and v_config_bom_exists = 0 ) then
1689:
1690: select concatenated_segments into v_model_item_name
1691: from mtl_system_items_kfv
1692: where inventory_item_id = pModelId
1693: and rownum = 1 ;
1694:
1695:

Line 1879: mtl_system_items msi

1875: p_atp_table.Error_Code ,
1876: p_atp_table.Message
1877: from oe_order_lines_all oel,
1878: oe_order_lines_all oel1,
1879: mtl_system_items msi
1880: where msi.inventory_item_id = oel.inventory_item_id
1881: and msi.organization_id = oel.ship_from_org_id
1882: and msi.bom_item_type = 1
1883: and oel.line_id = pLineId