DBA Data[Home] [Help]

APPS.CTO_SUBASSEMBLY_SUP_PK dependencies on MTL_SYSTEM_ITEMS_KFV

Line 31: item_name mtl_system_items_kfv.concatenated_segments%type,

27:
28: order_line_id number, --sales order line id
29: t_item_details_index number,
30: item_id bom_inventory_components.component_item_id%type,
31: item_name mtl_system_items_kfv.concatenated_segments%type,
32: item_quantity bom_inventory_components.component_quantity%type,
33: needed_item_qty bom_inventory_components.component_quantity%type,
34: OPERATION_LEAD_TIME_PERCENT bom_inventory_components.OPERATION_LEAD_TIME_PERCENT%type,
35: operation_seq_num bom_inventory_components.OPERATION_seq_num%type,

Line 38: fixed_lead_time mtl_system_items_kfv.fixed_lead_time%type,

34: OPERATION_LEAD_TIME_PERCENT bom_inventory_components.OPERATION_LEAD_TIME_PERCENT%type,
35: operation_seq_num bom_inventory_components.OPERATION_seq_num%type,
36: cfm_routing_flag bom_operational_routings.cfm_routing_flag%type,
37: routing_sequence_id bom_operational_routings.routing_sequence_id%type,
38: fixed_lead_time mtl_system_items_kfv.fixed_lead_time%type,
39: variable_lead_time mtl_system_items_kfv.variable_lead_time%type,
40: processing_lead_time mtl_system_items_kfv.full_lead_time%type,
41: postprocessing_lead_time mtl_system_items_kfv.postprocessing_lead_time%type,
42: bom_item_type bom_inventory_components.bom_item_type%type,

Line 39: variable_lead_time mtl_system_items_kfv.variable_lead_time%type,

35: operation_seq_num bom_inventory_components.OPERATION_seq_num%type,
36: cfm_routing_flag bom_operational_routings.cfm_routing_flag%type,
37: routing_sequence_id bom_operational_routings.routing_sequence_id%type,
38: fixed_lead_time mtl_system_items_kfv.fixed_lead_time%type,
39: variable_lead_time mtl_system_items_kfv.variable_lead_time%type,
40: processing_lead_time mtl_system_items_kfv.full_lead_time%type,
41: postprocessing_lead_time mtl_system_items_kfv.postprocessing_lead_time%type,
42: bom_item_type bom_inventory_components.bom_item_type%type,
43: auto_config_flag mtl_system_items_kfv.auto_created_config_flag%type,

Line 40: processing_lead_time mtl_system_items_kfv.full_lead_time%type,

36: cfm_routing_flag bom_operational_routings.cfm_routing_flag%type,
37: routing_sequence_id bom_operational_routings.routing_sequence_id%type,
38: fixed_lead_time mtl_system_items_kfv.fixed_lead_time%type,
39: variable_lead_time mtl_system_items_kfv.variable_lead_time%type,
40: processing_lead_time mtl_system_items_kfv.full_lead_time%type,
41: postprocessing_lead_time mtl_system_items_kfv.postprocessing_lead_time%type,
42: bom_item_type bom_inventory_components.bom_item_type%type,
43: auto_config_flag mtl_system_items_kfv.auto_created_config_flag%type,
44: parent_index number,

Line 41: postprocessing_lead_time mtl_system_items_kfv.postprocessing_lead_time%type,

37: routing_sequence_id bom_operational_routings.routing_sequence_id%type,
38: fixed_lead_time mtl_system_items_kfv.fixed_lead_time%type,
39: variable_lead_time mtl_system_items_kfv.variable_lead_time%type,
40: processing_lead_time mtl_system_items_kfv.full_lead_time%type,
41: postprocessing_lead_time mtl_system_items_kfv.postprocessing_lead_time%type,
42: bom_item_type bom_inventory_components.bom_item_type%type,
43: auto_config_flag mtl_system_items_kfv.auto_created_config_flag%type,
44: parent_index number,
45: job_start_date date,

Line 43: auto_config_flag mtl_system_items_kfv.auto_created_config_flag%type,

39: variable_lead_time mtl_system_items_kfv.variable_lead_time%type,
40: processing_lead_time mtl_system_items_kfv.full_lead_time%type,
41: postprocessing_lead_time mtl_system_items_kfv.postprocessing_lead_time%type,
42: bom_item_type bom_inventory_components.bom_item_type%type,
43: auto_config_flag mtl_system_items_kfv.auto_created_config_flag%type,
44: parent_index number,
45: job_start_date date,
46: job_completion_date date,
47: populate_start_date number, -- value of 1 implies 1implies insert satrt date in wjsi instead of completion date, while finite scheduler is on