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 CZ_ATP_REQUESTS

Line 74: configurator_session_key cz_atp_requests.configurator_session_key%type ,

70: ** This record holds processed information for atp requests from configurator
71: */
72: TYPE CZ_REQUESTS_TYPE IS RECORD (
73: ship_set_name varchar2(200) ,
74: configurator_session_key cz_atp_requests.configurator_session_key%type ,
75: seq_no cz_atp_requests.seq_no%type ,
76: Item_key cz_atp_requests.item_key%type ,
77: quantity cz_atp_requests.quantity%type ,
78: UOM_CODE cz_atp_requests.UOM_CODE%type ,

Line 75: seq_no cz_atp_requests.seq_no%type ,

71: */
72: TYPE CZ_REQUESTS_TYPE IS RECORD (
73: ship_set_name varchar2(200) ,
74: configurator_session_key cz_atp_requests.configurator_session_key%type ,
75: seq_no cz_atp_requests.seq_no%type ,
76: Item_key cz_atp_requests.item_key%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 ,

Line 76: Item_key cz_atp_requests.item_key%type ,

72: TYPE CZ_REQUESTS_TYPE IS RECORD (
73: ship_set_name varchar2(200) ,
74: configurator_session_key cz_atp_requests.configurator_session_key%type ,
75: seq_no cz_atp_requests.seq_no%type ,
76: Item_key cz_atp_requests.item_key%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 ,

Line 77: quantity cz_atp_requests.quantity%type ,

73: ship_set_name varchar2(200) ,
74: configurator_session_key cz_atp_requests.configurator_session_key%type ,
75: seq_no cz_atp_requests.seq_no%type ,
76: Item_key cz_atp_requests.item_key%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 ,

Line 78: UOM_CODE cz_atp_requests.UOM_CODE%type ,

74: configurator_session_key cz_atp_requests.configurator_session_key%type ,
75: seq_no cz_atp_requests.seq_no%type ,
76: Item_key cz_atp_requests.item_key%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 ,

Line 79: inv_org_id cz_atp_requests.inv_org_id%type ,

75: seq_no cz_atp_requests.seq_no%type ,
76: Item_key cz_atp_requests.item_key%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 ,

Line 80: ship_To_date cz_atp_requests.ship_to_date%type ,

76: Item_key cz_atp_requests.item_key%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 ,

Line 82: self_code cz_atp_requests.item_key%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 */
86: parent_config_item_id cz_atp_requests.parent_config_item_id%type , /* Added for MI */

Line 83: parent_code cz_atp_requests.item_key%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 */
86: parent_config_item_id cz_atp_requests.parent_config_item_id%type , /* Added for MI */
87: line_id number ,

Line 84: top_model_code cz_atp_requests.item_key%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 */
86: parent_config_item_id cz_atp_requests.parent_config_item_id%type , /* Added for MI */
87: line_id number ,
88: link_to_line_id number ,

Line 85: config_item_id cz_atp_requests.config_item_id%type , /* Added for MI */

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 */
86: parent_config_item_id cz_atp_requests.parent_config_item_id%type , /* Added for MI */
87: line_id number ,
88: link_to_line_id number ,
89: ato_line_id number ,

Line 86: parent_config_item_id cz_atp_requests.parent_config_item_id%type , /* Added for MI */

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 */
86: parent_config_item_id cz_atp_requests.parent_config_item_id%type , /* Added for MI */
87: line_id number ,
88: link_to_line_id number ,
89: ato_line_id number ,
90: item_type_code oe_order_lines.item_type_code%type ,

Line 2087: ** CZ store information in CZ_ATP_REQUESTS table. The format of this information does

2083:
2084: /*
2085: ** This procedure does the preprocessing and data collection for calls
2086: ** originating from CZ.
2087: ** CZ store information in CZ_ATP_REQUESTS table. The format of this information does
2088: ** not match with data structure required for evaluate shipset function. Hence this data
2089: ** needs to be transformed from CZ_REQUEST_TYPE data structure to CTO_SHIPSET_TYPE data structure.
2090: ** Model/Component relationships ( link_to_line_id, ato_line_id) need to be established before
2091: ** transformation.

Line 2113: v_component_code cz_atp_requests.item_key%type ;

2109: v_top_model_line_id number ;
2110: c_organization_id number ;
2111: v_requests_tab CZ_REQUESTS_TBL_TYPE ;
2112: v_index number(10) := 0 ;
2113: v_component_code cz_atp_requests.item_key%type ;
2114: v_top_model_code cz_atp_requests.item_key%type ;
2115: v_match_component_code cz_atp_requests.item_key%type ;
2116: v_code_loc number(10) ;
2117: v_parent_found boolean ;

Line 2114: v_top_model_code cz_atp_requests.item_key%type ;

2110: c_organization_id number ;
2111: v_requests_tab CZ_REQUESTS_TBL_TYPE ;
2112: v_index number(10) := 0 ;
2113: v_component_code cz_atp_requests.item_key%type ;
2114: v_top_model_code cz_atp_requests.item_key%type ;
2115: v_match_component_code cz_atp_requests.item_key%type ;
2116: v_code_loc number(10) ;
2117: v_parent_found boolean ;
2118: v_parent_loc number(10) ;

Line 2115: v_match_component_code cz_atp_requests.item_key%type ;

2111: v_requests_tab CZ_REQUESTS_TBL_TYPE ;
2112: v_index number(10) := 0 ;
2113: v_component_code cz_atp_requests.item_key%type ;
2114: v_top_model_code cz_atp_requests.item_key%type ;
2115: v_match_component_code cz_atp_requests.item_key%type ;
2116: v_code_loc number(10) ;
2117: v_parent_found boolean ;
2118: v_parent_loc number(10) ;
2119: cursor c1 (c_session_key cz_atp_requests.configurator_session_key%type )

Line 2119: cursor c1 (c_session_key cz_atp_requests.configurator_session_key%type )

2115: v_match_component_code cz_atp_requests.item_key%type ;
2116: v_code_loc number(10) ;
2117: v_parent_found boolean ;
2118: v_parent_loc number(10) ;
2119: cursor c1 (c_session_key cz_atp_requests.configurator_session_key%type )
2120: is
2121: select Item_key, quantity, UOM_CODE, ship_To_date
2122: from cz_atp_requests where configurator_session_key = c_session_key ;
2123: x_msg_count number ;

Line 2122: from cz_atp_requests where configurator_session_key = c_session_key ;

2118: v_parent_loc number(10) ;
2119: cursor c1 (c_session_key cz_atp_requests.configurator_session_key%type )
2120: is
2121: select Item_key, quantity, UOM_CODE, ship_To_date
2122: from cz_atp_requests where configurator_session_key = c_session_key ;
2123: x_msg_count number ;
2124: x_msg_data varchar2(2000) ;
2125: l_stmt_num number ;
2126: v_bill_sequence_id bom_bill_of_materials.bill_sequence_id%type ;

Line 2175: from cz_atp_requests

2171: , g_requests_tab(v_index).inventory_item_id
2172: /* line to be commented if noncz */
2173: , g_requests_tab(v_index).config_item_id /*BUG#2250621 Multiple Instantiation Code Change */
2174: , g_requests_tab(v_index).parent_config_item_id /*BUG#2250621 Multiple Instantiation Code Change */
2175: from cz_atp_requests
2176: where atp_request_id = p_shipset.identifier(v_location) ;
2177: /* line to be commented if noncz */
2178:
2179: l_stmt_num := 10 ;