101: | |
102: +===========================================================================*/
103:
104: PROCEDURE get_item_flex_defaults(p_inventory_item_id IN
105: mtl_system_items.inventory_item_id%type,
106: p_organization_id IN
107: mtl_system_items.organization_id%type,
108: p_trx_date IN
109: ra_customer_trx.trx_date%type,
103:
104: PROCEDURE get_item_flex_defaults(p_inventory_item_id IN
105: mtl_system_items.inventory_item_id%type,
106: p_organization_id IN
107: mtl_system_items.organization_id%type,
108: p_trx_date IN
109: ra_customer_trx.trx_date%type,
110: p_invoicing_rule_id IN
111: ra_customer_trx.invoicing_rule_id%type,
109: ra_customer_trx.trx_date%type,
110: p_invoicing_rule_id IN
111: ra_customer_trx.invoicing_rule_id%type,
112: p_description OUT NOCOPY
113: mtl_system_items.description%type,
114: p_primary_uom_code OUT NOCOPY
115: mtl_system_items.primary_uom_code%type,
116: p_primary_uom_name OUT NOCOPY
117: mtl_units_of_measure.unit_of_measure%type,
111: ra_customer_trx.invoicing_rule_id%type,
112: p_description OUT NOCOPY
113: mtl_system_items.description%type,
114: p_primary_uom_code OUT NOCOPY
115: mtl_system_items.primary_uom_code%type,
116: p_primary_uom_name OUT NOCOPY
117: mtl_units_of_measure.unit_of_measure%type,
118: p_accounting_rule_id OUT NOCOPY
119: mtl_system_items.accounting_rule_id%type,
115: mtl_system_items.primary_uom_code%type,
116: p_primary_uom_name OUT NOCOPY
117: mtl_units_of_measure.unit_of_measure%type,
118: p_accounting_rule_id OUT NOCOPY
119: mtl_system_items.accounting_rule_id%type,
120: p_accounting_rule_name OUT NOCOPY
121: ra_rules.name%type,
122: p_accounting_rule_duration OUT NOCOPY
123: ra_rules.occurrences%type,
176: p_accounting_rule_name,
177: p_accounting_rule_duration,
178: p_accounting_rule_type,
179: p_rule_start_date
180: FROM mtl_system_items msi,
181: mtl_units_of_measure muom,
182: ra_rules rr,
183: ra_rule_schedules rs
184: WHERE msi.inventory_item_id = p_inventory_item_id