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: --Bugfix 11056452
494: lCnt number;
495:

Line 775: from mtl_system_items msi,

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

Line 785: from mtl_system_items msi,

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

Line 807: mtl_system_items msi,

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

Line 873: from mtl_system_items_kfv msi,

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

Line 894: from mtl_system_items_kfv msi,

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

Line 933: from mtl_system_items_kfv

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

Line 1083: from mtl_system_items

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

Line 1089: from mtl_system_items

1085: and rownum = 1 ;
1086:
1087: select segment1
1088: into v_problem_config
1089: from mtl_system_items
1090: where inventory_item_id = pConfigId
1091: and rownum = 1 ;
1092:
1093: select organization_name

Line 1132: from mtl_system_items

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

Line 1138: from mtl_system_items

1134: and rownum = 1 ;
1135:
1136: select segment1
1137: into v_problem_config
1138: from mtl_system_items
1139: where inventory_item_id = pConfigId
1140: and rownum = 1 ;
1141:
1142: select organization_name

Line 1194: from mtl_system_items

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

Line 1200: from mtl_system_items

1196: and rownum = 1 ;
1197:
1198: select segment1
1199: into v_problem_config
1200: from mtl_system_items
1201: where inventory_item_id = pConfigId
1202: and rownum = 1 ;
1203:
1204: select organization_name

Line 1274: FROM mtl_system_items_vl item

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

Line 1317: from mtl_system_items

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

Line 1323: from mtl_system_items

1319: and rownum = 1 ;
1320:
1321: select segment1
1322: into v_problem_config
1323: from mtl_system_items
1324: where inventory_item_id = pConfigId
1325: and rownum = 1 ;
1326: select organization_name
1327: into v_error_org

Line 1387: FROM mtl_system_items_vl item

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

Line 1751: from mtl_system_items_kfv

1747:
1748: if( v_bom_created = 0 and v_config_bom_exists = 0 ) then
1749:
1750: select concatenated_segments into v_model_item_name
1751: from mtl_system_items_kfv
1752: where inventory_item_id = pModelId
1753: and rownum = 1 ;
1754:
1755:

Line 1939: mtl_system_items msi

1935: p_atp_table.Error_Code ,
1936: p_atp_table.Message
1937: from oe_order_lines_all oel,
1938: oe_order_lines_all oel1,
1939: mtl_system_items msi
1940: where msi.inventory_item_id = oel.inventory_item_id
1941: and msi.organization_id = oel.ship_from_org_id
1942: and msi.bom_item_type = 1
1943: and oel.line_id = pLineId