APPS.CTO_RESERVE_CONFIG dependencies on OE_ORDER_LINES

Line 30: Parameters: model_line_id - line id of the top model in oe_order_lines

26: =============================================================================*/
27:
28: /*****************************************************************************
29: Function: reserve_config
30: Parameters: model_line_id - line id of the top model in oe_order_lines
31: match_config_id - config id of the matching configuration
32: from bom_ato_configurations
33: error_message - error message if match function fails
34: message_name - name of error message if match function fails

Line 38: configuration in oe_order_lines.

34: message_name - name of error message if match function fails
35:
36: Description: This function looks for a configuration in
37: bom_ato_configurations that matches the ordered
38: configuration in oe_order_lines.
39:
40: *****************************************************************************/
41: TYPE rec_reserve IS RECORD (
42: f_header_id number,

Line 43: f_line_id oe_order_lines.line_id%TYPE,

39:
40: *****************************************************************************/
41: TYPE rec_reserve IS RECORD (
42: f_header_id number,
43: f_line_id oe_order_lines.line_id%TYPE,
44: f_mfg_org_id oe_order_lines.ship_from_org_id%TYPE,
45: f_item_id oe_order_lines.inventory_item_id%TYPE,
46: f_order_qty_uom oe_order_lines.order_quantity_uom%TYPE,
47: f_quantity number,

Line 44: f_mfg_org_id oe_order_lines.ship_from_org_id%TYPE,

40: *****************************************************************************/
41: TYPE rec_reserve IS RECORD (
42: f_header_id number,
43: f_line_id oe_order_lines.line_id%TYPE,
44: f_mfg_org_id oe_order_lines.ship_from_org_id%TYPE,
45: f_item_id oe_order_lines.inventory_item_id%TYPE,
46: f_order_qty_uom oe_order_lines.order_quantity_uom%TYPE,
47: f_quantity number,
48: f_supply_source number,

Line 45: f_item_id oe_order_lines.inventory_item_id%TYPE,

41: TYPE rec_reserve IS RECORD (
42: f_header_id number,
43: f_line_id oe_order_lines.line_id%TYPE,
44: f_mfg_org_id oe_order_lines.ship_from_org_id%TYPE,
45: f_item_id oe_order_lines.inventory_item_id%TYPE,
46: f_order_qty_uom oe_order_lines.order_quantity_uom%TYPE,
47: f_quantity number,
48: f_supply_source number,
49: f_supply_header_id number,

Line 46: f_order_qty_uom oe_order_lines.order_quantity_uom%TYPE,

42: f_header_id number,
43: f_line_id oe_order_lines.line_id%TYPE,
44: f_mfg_org_id oe_order_lines.ship_from_org_id%TYPE,
45: f_item_id oe_order_lines.inventory_item_id%TYPE,
46: f_order_qty_uom oe_order_lines.order_quantity_uom%TYPE,
47: f_quantity number,
48: f_supply_source number,
49: f_supply_header_id number,
50: f_ship_date oe_order_lines.schedule_ship_date%TYPE,

Line 50: f_ship_date oe_order_lines.schedule_ship_date%TYPE,

46: f_order_qty_uom oe_order_lines.order_quantity_uom%TYPE,
47: f_quantity number,
48: f_supply_source number,
49: f_supply_header_id number,
50: f_ship_date oe_order_lines.schedule_ship_date%TYPE,
51: f_source_document_type_id oe_order_headers.source_document_type_id%TYPE default NULL,
52: -- bugfix 1799874: added f_source_document_type_id
53: f_bom_revision mtl_item_revisions.revision%TYPE
54: -- 2620282 : Add new column to store bom revision