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

Line 40: bom_item_type mtl_system_items.bom_item_type%type ,

36: link_to_line_id number ,
37: inventory_item_id oe_order_lines.inventory_item_id%type ,
38: item_type_code oe_order_lines.item_type_code%type ,
39: wip_supply_type bom_inventory_components.wip_supply_type%type ,
40: bom_item_type mtl_system_items.bom_item_type%type ,
41: replenish_to_order_flag mtl_system_items.replenish_to_order_flag%type ,
42: pick_components_flag mtl_system_items.pick_components_flag%type ,
43: base_item_id mtl_system_items.base_item_id%type ,
44: build_in_wip_flag mtl_system_items.build_in_wip_flag%type ,

Line 41: replenish_to_order_flag mtl_system_items.replenish_to_order_flag%type ,

37: inventory_item_id oe_order_lines.inventory_item_id%type ,
38: item_type_code oe_order_lines.item_type_code%type ,
39: wip_supply_type bom_inventory_components.wip_supply_type%type ,
40: bom_item_type mtl_system_items.bom_item_type%type ,
41: replenish_to_order_flag mtl_system_items.replenish_to_order_flag%type ,
42: pick_components_flag mtl_system_items.pick_components_flag%type ,
43: base_item_id mtl_system_items.base_item_id%type ,
44: build_in_wip_flag mtl_system_items.build_in_wip_flag%type ,
45: buy_model varchar2(1) , /* added for procure config 'B', 'Y' , 'N' */

Line 42: pick_components_flag mtl_system_items.pick_components_flag%type ,

38: item_type_code oe_order_lines.item_type_code%type ,
39: wip_supply_type bom_inventory_components.wip_supply_type%type ,
40: bom_item_type mtl_system_items.bom_item_type%type ,
41: replenish_to_order_flag mtl_system_items.replenish_to_order_flag%type ,
42: pick_components_flag mtl_system_items.pick_components_flag%type ,
43: base_item_id mtl_system_items.base_item_id%type ,
44: build_in_wip_flag mtl_system_items.build_in_wip_flag%type ,
45: buy_model varchar2(1) , /* added for procure config 'B', 'Y' , 'N' */
46: /* value 'B' has been introduced to flag the top buy model. value 'Y' has been ointroduced to flag all the buy model components excluding the top buy model. The attribute_05 = 'N' will be set for visible demand */

Line 43: base_item_id mtl_system_items.base_item_id%type ,

39: wip_supply_type bom_inventory_components.wip_supply_type%type ,
40: bom_item_type mtl_system_items.bom_item_type%type ,
41: replenish_to_order_flag mtl_system_items.replenish_to_order_flag%type ,
42: pick_components_flag mtl_system_items.pick_components_flag%type ,
43: base_item_id mtl_system_items.base_item_id%type ,
44: build_in_wip_flag mtl_system_items.build_in_wip_flag%type ,
45: buy_model varchar2(1) , /* added for procure config 'B', 'Y' , 'N' */
46: /* value 'B' has been introduced to flag the top buy model. value 'Y' has been ointroduced to flag all the buy model components excluding the top buy model. The attribute_05 = 'N' will be set for visible demand */
47:

Line 44: build_in_wip_flag mtl_system_items.build_in_wip_flag%type ,

40: bom_item_type mtl_system_items.bom_item_type%type ,
41: replenish_to_order_flag mtl_system_items.replenish_to_order_flag%type ,
42: pick_components_flag mtl_system_items.pick_components_flag%type ,
43: base_item_id mtl_system_items.base_item_id%type ,
44: build_in_wip_flag mtl_system_items.build_in_wip_flag%type ,
45: buy_model varchar2(1) , /* added for procure config 'B', 'Y' , 'N' */
46: /* value 'B' has been introduced to flag the top buy model. value 'Y' has been ointroduced to flag all the buy model components excluding the top buy model. The attribute_05 = 'N' will be set for visible demand */
47:
48: configuration_exists varchar2(1), /* 'Y' , 'N' to indicate configuration exists, this data will be used to decide what to populate in visible demand flag */

Line 81: inventory_item_id mtl_system_items.inventory_item_id%type ,

77: quantity cz_atp_requests.quantity%type ,
78: UOM_CODE cz_atp_requests.UOM_CODE%type ,
79: inv_org_id cz_atp_requests.inv_org_id%type ,
80: ship_To_date cz_atp_requests.ship_to_date%type ,
81: inventory_item_id mtl_system_items.inventory_item_id%type ,
82: self_code cz_atp_requests.item_key%type ,
83: parent_code cz_atp_requests.item_key%type ,
84: top_model_code cz_atp_requests.item_key%type ,
85: config_item_id cz_atp_requests.config_item_id%type , /* Added for MI */

Line 92: bom_item_type mtl_system_items.bom_item_type%type ,

88: link_to_line_id number ,
89: ato_line_id number ,
90: item_type_code oe_order_lines.item_type_code%type ,
91: wip_supply_type bom_inventory_components.wip_supply_type%type ,
92: bom_item_type mtl_system_items.bom_item_type%type ,
93: replenish_to_order_flag mtl_system_items.replenish_to_order_flag%type ,
94: pick_components_flag mtl_system_items.pick_components_flag%type ,
95: base_item_id mtl_system_items.base_item_id%type ,
96: build_in_wip_flag mtl_system_items.build_in_wip_flag%type ,

Line 93: replenish_to_order_flag mtl_system_items.replenish_to_order_flag%type ,

89: ato_line_id number ,
90: item_type_code oe_order_lines.item_type_code%type ,
91: wip_supply_type bom_inventory_components.wip_supply_type%type ,
92: bom_item_type mtl_system_items.bom_item_type%type ,
93: replenish_to_order_flag mtl_system_items.replenish_to_order_flag%type ,
94: pick_components_flag mtl_system_items.pick_components_flag%type ,
95: base_item_id mtl_system_items.base_item_id%type ,
96: build_in_wip_flag mtl_system_items.build_in_wip_flag%type ,
97: top_model_ato boolean ,

Line 94: pick_components_flag mtl_system_items.pick_components_flag%type ,

90: item_type_code oe_order_lines.item_type_code%type ,
91: wip_supply_type bom_inventory_components.wip_supply_type%type ,
92: bom_item_type mtl_system_items.bom_item_type%type ,
93: replenish_to_order_flag mtl_system_items.replenish_to_order_flag%type ,
94: pick_components_flag mtl_system_items.pick_components_flag%type ,
95: base_item_id mtl_system_items.base_item_id%type ,
96: build_in_wip_flag mtl_system_items.build_in_wip_flag%type ,
97: top_model_ato boolean ,
98: top_model_line_id number ,

Line 95: base_item_id mtl_system_items.base_item_id%type ,

91: wip_supply_type bom_inventory_components.wip_supply_type%type ,
92: bom_item_type mtl_system_items.bom_item_type%type ,
93: replenish_to_order_flag mtl_system_items.replenish_to_order_flag%type ,
94: pick_components_flag mtl_system_items.pick_components_flag%type ,
95: base_item_id mtl_system_items.base_item_id%type ,
96: build_in_wip_flag mtl_system_items.build_in_wip_flag%type ,
97: top_model_ato boolean ,
98: top_model_line_id number ,
99: assigned boolean ,

Line 96: build_in_wip_flag mtl_system_items.build_in_wip_flag%type ,

92: bom_item_type mtl_system_items.bom_item_type%type ,
93: replenish_to_order_flag mtl_system_items.replenish_to_order_flag%type ,
94: pick_components_flag mtl_system_items.pick_components_flag%type ,
95: base_item_id mtl_system_items.base_item_id%type ,
96: build_in_wip_flag mtl_system_items.build_in_wip_flag%type ,
97: top_model_ato boolean ,
98: top_model_line_id number ,
99: assigned boolean ,
100: location number ,

Line 2328: from Mtl_system_items MSYI

2324: , g_requests_tab(j).base_item_id
2325: , g_requests_tab(j).build_in_wip_flag
2326: , g_requests_tab(j).atp_flag
2327: , g_requests_tab(j).atp_components_flag
2328: from Mtl_system_items MSYI
2329: where MSYI.inventory_item_id = g_requests_tab(j).inventory_item_id
2330: and MSYI.organization_id = l_validation_org ;
2331: /*
2332: ** find bill sequence id for parent item

Line 2640: from oe_order_lines_all OEOL , bom_inventory_components BIC , mtl_system_items MSYI

2636: , p_orig_shipset_tracker(j).build_in_wip_flag
2637: , p_orig_shipset_tracker(j).atp_flag
2638: , p_orig_shipset_tracker(j).atp_components_flag
2639: , p_orig_shipset_tracker(j).mlmo_flag -- 2723674 : Initializing MLMO flag
2640: from oe_order_lines_all OEOL , bom_inventory_components BIC , mtl_system_items MSYI
2641: where line_id = p_shipset.identifier(j)
2642: and OEOL.component_sequence_id = BIC.component_sequence_id(+)
2643: and MSYI.inventory_item_id = p_shipset.inventory_item_id(j)
2644: and MSYI.organization_id = l_validation_org

Line 2841: FROM MTL_SYSTEM_ITEMS

2837: --- so that the calling application will knwo this as buy model
2838:
2839: SELECT planning_make_buy_code
2840: INTO l_make_buy_code
2841: FROM MTL_SYSTEM_ITEMS
2842: WHERE inventory_item_id = local_cto_shipset(p_location).inventory_item_id
2843: AND organization_id = p_org;
2844:
2845: IF l_make_buy_code = 2 THEN

Line 3228: FROM MTL_SYSTEM_ITEMS

3224: --- so that the calling application will knwo this as buy model
3225:
3226: SELECT planning_make_buy_code
3227: INTO l_make_buy_code
3228: FROM MTL_SYSTEM_ITEMS
3229: WHERE inventory_item_id = p_inventory_item_id
3230: AND organization_id = p_organization_id;
3231:
3232: IF l_make_buy_code = 2 THEN

Line 4807: l_bom_item_type mtl_system_items.bom_item_type%type ;

4803: l_buy_flag VARCHAR2(1);
4804: i NUMBER := 0;
4805: lStmtNum NUMBER;
4806:
4807: l_bom_item_type mtl_system_items.bom_item_type%type ;
4808:
4809: BEGIN
4810: IF PG_DEBUG <> 0 THEN
4811: oe_debug_pub.add('create_atp_bom: ' || 'Begin BOM creation', 2);

Line 4921: from mtl_system_items

4917: We will pass fixed, variable and pre-processing lead
4918: times in the BOM and ATP will do the calculations*/
4919: select nvl(fixed_lead_time, 0), nvl(variable_lead_time, 0), nvl(preprocessing_lead_time, 0)
4920: into l_fixed_lt, l_variable_lt, l_preproc_lt
4921: from mtl_system_items
4922: where inventory_item_id = g_cto_sparse_shipset(l_parent_id).Inventory_Item_Id
4923: and organization_id = g_cto_sparse_shipset(l_parent_id).Sourcing_Org;
4924: IF PG_DEBUG <> 0 THEN
4925: oe_debug_pub.add('**create_atp_bom: ' || 'After getting LT', 5);

Line 4935: from mtl_system_items

4931: lStmtNum := 75;
4932: /*Populate atp_flag for each component and send to ATP (bug 2462661)*/
4933: select atp_flag, atp_components_flag, bom_item_type
4934: into l_atp_flag, l_atp_comps_flag, l_bom_item_type
4935: from mtl_system_items
4936: where inventory_item_id = g_cto_sparse_shipset(l_index).Inventory_Item_Id
4937: and organization_id = g_cto_sparse_shipset(l_index).Sourcing_Org;
4938: IF PG_DEBUG <> 0 THEN
4939: oe_debug_pub.add('**create_atp_bom: ' || 'After getting atp flags', 5);

Line 5395: from mtl_system_items

5391: -- Lead time required for all items (bug 2560915)
5392: --
5393: select nvl(fixed_lead_time, 0), nvl(variable_lead_time, 0), nvl(preprocessing_lead_time, 0)
5394: into l_fixed_lt, l_variable_lt, l_preproc_lt
5395: from mtl_system_items
5396: where inventory_item_id = g_cto_sparse_shipset(l_new_model_line_id).Inventory_Item_Id
5397: and organization_id = g_cto_sparse_shipset(l_new_model_line_id).Sourcing_Org;
5398:
5399: lStmtNum := 150;

Line 5410: from mtl_system_items

5406: --
5407: lStmtNum := 160;
5408: select atp_flag, atp_components_flag
5409: into l_atp_flag, l_atp_comps_flag
5410: from mtl_system_items
5411: where inventory_item_id = nxtrec.component_item_id
5412: and organization_id = g_cto_sparse_shipset(l_new_model_line_id).Sourcing_Org;
5413:
5414: lStmtNum := 170;

Line 5941: mtl_system_items msi

5937: into l_par_line_id,
5938: l_par_inventory_item_id,
5939: l_par_bom_item_type
5940: from oe_order_lines_all oel,
5941: mtl_system_items msi
5942: where oel.line_id = g_final_cto_shipset(i).link_to_line_id
5943: and oel.inventory_item_id = msi.inventory_item_id
5944: and oel.ship_from_org_id = msi.organization_id;
5945:

Line 6020: from mtl_system_items

6016: select nvl(fixed_lead_time,0),
6017: nvl(variable_lead_time,0)
6018: into l_fixed_lead_time,
6019: l_variable_lead_time
6020: from mtl_system_items
6021: where inventory_item_id = l_par_inventory_item_id
6022: and organization_id = g_final_cto_shipset(i).sourcing_org;
6023:
6024: x_lead_time := l_fixed_lead_time +

Line 6318: l_org_id mtl_system_items.organization_id%type;

6314: l_order_quantity_uom varchar2(3);
6315: l_record_count number;
6316: l_header_id oe_order_lines_all.header_id%type;
6317: l_line_id oe_order_lines_all.line_id%type;
6318: l_org_id mtl_system_items.organization_id%type;
6319: l_inv_item_id mtl_system_items.inventory_item_id%type;
6320: ATP_NO_RECORD_ERROR EXCEPTION;
6321: l_stmt_no number;
6322: BEGIN

Line 6319: l_inv_item_id mtl_system_items.inventory_item_id%type;

6315: l_record_count number;
6316: l_header_id oe_order_lines_all.header_id%type;
6317: l_line_id oe_order_lines_all.line_id%type;
6318: l_org_id mtl_system_items.organization_id%type;
6319: l_inv_item_id mtl_system_items.inventory_item_id%type;
6320: ATP_NO_RECORD_ERROR EXCEPTION;
6321: l_stmt_no number;
6322: BEGIN
6323:

Line 6491: PROCEDURE ato_item_exp(p_item_id mtl_system_items.inventory_item_id%type,

6487: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6488: END Create_demand_line;
6489:
6490:
6491: PROCEDURE ato_item_exp(p_item_id mtl_system_items.inventory_item_id%type,
6492: p_org_id mtl_system_items.organization_id%type,
6493: p_qty number,
6494: p_req_date date,
6495: p_line_id number,

Line 6492: p_org_id mtl_system_items.organization_id%type,

6488: END Create_demand_line;
6489:
6490:
6491: PROCEDURE ato_item_exp(p_item_id mtl_system_items.inventory_item_id%type,
6492: p_org_id mtl_system_items.organization_id%type,
6493: p_qty number,
6494: p_req_date date,
6495: p_line_id number,
6496: p_header_id number,

Line 6826: PROCEDURE ato_item_exp(p_item_id mtl_system_items.inventory_item_id%type,

6822:
6823:
6824:
6825: /************************************************************************/
6826: PROCEDURE ato_item_exp(p_item_id mtl_system_items.inventory_item_id%type,
6827: p_org_id mtl_system_items.organization_id%type,
6828: p_qty number,
6829: p_req_date date,
6830: p_line_id number,

Line 6827: p_org_id mtl_system_items.organization_id%type,

6823:
6824:
6825: /************************************************************************/
6826: PROCEDURE ato_item_exp(p_item_id mtl_system_items.inventory_item_id%type,
6827: p_org_id mtl_system_items.organization_id%type,
6828: p_qty number,
6829: p_req_date date,
6830: p_line_id number,
6831: p_header_id number,

Line 6849: mtl_system_items mtl

6845: cursor inven_comp is
6846: SELECT component_item_id,component_quantity
6847: FROM bom_inventory_components bic,
6848: bom_bill_of_materials bom,
6849: mtl_system_items mtl
6850: WHERE bom.assembly_item_id = p_item_id
6851: AND bom.organization_id = x_source_org
6852: AND bom.bill_sequence_id = bic.bill_sequence_id
6853: AND bic.bom_item_type = 4

Line 6897: from mtl_system_items

6893: END IF;
6894:
6895: select nvl(fixed_lead_time,0),nvl(variable_lead_time,0)
6896: into l_fixed_lead_time,l_variable_lead_time
6897: from mtl_system_items
6898: where inventory_item_id = p_item_id
6899: and organization_id = x_source_org;
6900: x_lead_time := nvl(x_lead_time,0) + l_fixed_lead_time +
6901: l_variable_lead_time * p_qty;

Line 7015: mtl_system_items mtl

7011: sysdate
7012: From
7013: bom_inventory_components bic,
7014: bom_bill_of_materials bom,
7015: mtl_system_items mtl
7016: where bom.assembly_item_id = p_item_id
7017: and bom.organization_id = p_org_id
7018: and bom.bill_sequence_id = bic.bill_sequence_id
7019: and bic.bom_item_type in (1,2)

Line 7064: mtl_system_items mtl

7060: null, -- Program_application_id
7061: sysdate
7062: from bom_inventory_components bic,
7063: bom_bill_of_materials bom,
7064: mtl_system_items mtl
7065: where bom.assembly_item_id = p_item_id
7066: and bom.organization_id = p_org_id
7067: and bom.bill_sequence_id = bic.bill_sequence_id
7068: and bic.bom_item_type = 4

Line 7109: mtl_system_items mtl

7105: cursor atoitem is
7106: select component_item_id
7107: from bom_bill_of_materials bom,
7108: bom_inventory_components bic,
7109: mtl_system_items mtl
7110: where bom.assembly_item_id = p_item_id
7111: and bom.organization_id = p_org_id
7112: and bom.bill_sequence_id = bic.bill_sequence_id
7113: and bic.bom_item_type = 4