DBA Data[Home] [Help]

APPS.INV_MGD_MVT_DATA_STR dependencies on MTL_STAT_TYPE_USAGES

Line 302: ( legal_entity_id mtl_stat_type_usages.legal_entity_id%TYPE

298:
299: --Bug: 5920143. New column include_establishments has beed added in
300: -- record definition.
301: TYPE Movement_Stat_Usages_Rec_Type IS RECORD
302: ( legal_entity_id mtl_stat_type_usages.legal_entity_id%TYPE
303: , zone_code mtl_stat_type_usages.zone_code%TYPE
304: , usage_type mtl_stat_type_usages.usage_type%TYPE
305: , stat_type mtl_stat_type_usages.stat_type%TYPE
306: , start_date DATE

Line 303: , zone_code mtl_stat_type_usages.zone_code%TYPE

299: --Bug: 5920143. New column include_establishments has beed added in
300: -- record definition.
301: TYPE Movement_Stat_Usages_Rec_Type IS RECORD
302: ( legal_entity_id mtl_stat_type_usages.legal_entity_id%TYPE
303: , zone_code mtl_stat_type_usages.zone_code%TYPE
304: , usage_type mtl_stat_type_usages.usage_type%TYPE
305: , stat_type mtl_stat_type_usages.stat_type%TYPE
306: , start_date DATE
307: , end_date DATE

Line 304: , usage_type mtl_stat_type_usages.usage_type%TYPE

300: -- record definition.
301: TYPE Movement_Stat_Usages_Rec_Type IS RECORD
302: ( legal_entity_id mtl_stat_type_usages.legal_entity_id%TYPE
303: , zone_code mtl_stat_type_usages.zone_code%TYPE
304: , usage_type mtl_stat_type_usages.usage_type%TYPE
305: , stat_type mtl_stat_type_usages.stat_type%TYPE
306: , start_date DATE
307: , end_date DATE
308: , conversion_option mtl_stat_type_usages.conversion_option%TYPE

Line 305: , stat_type mtl_stat_type_usages.stat_type%TYPE

301: TYPE Movement_Stat_Usages_Rec_Type IS RECORD
302: ( legal_entity_id mtl_stat_type_usages.legal_entity_id%TYPE
303: , zone_code mtl_stat_type_usages.zone_code%TYPE
304: , usage_type mtl_stat_type_usages.usage_type%TYPE
305: , stat_type mtl_stat_type_usages.stat_type%TYPE
306: , start_date DATE
307: , end_date DATE
308: , conversion_option mtl_stat_type_usages.conversion_option%TYPE
309: , conversion_type mtl_stat_type_usages.conversion_type%TYPE

Line 308: , conversion_option mtl_stat_type_usages.conversion_option%TYPE

304: , usage_type mtl_stat_type_usages.usage_type%TYPE
305: , stat_type mtl_stat_type_usages.stat_type%TYPE
306: , start_date DATE
307: , end_date DATE
308: , conversion_option mtl_stat_type_usages.conversion_option%TYPE
309: , conversion_type mtl_stat_type_usages.conversion_type%TYPE
310: , category_set_id mtl_stat_type_usages.category_set_id%TYPE
311: , weight_uom_code mtl_stat_type_usages.weight_uom_code%TYPE
312: , gl_currency_code VARCHAR2(15)

Line 309: , conversion_type mtl_stat_type_usages.conversion_type%TYPE

305: , stat_type mtl_stat_type_usages.stat_type%TYPE
306: , start_date DATE
307: , end_date DATE
308: , conversion_option mtl_stat_type_usages.conversion_option%TYPE
309: , conversion_type mtl_stat_type_usages.conversion_type%TYPE
310: , category_set_id mtl_stat_type_usages.category_set_id%TYPE
311: , weight_uom_code mtl_stat_type_usages.weight_uom_code%TYPE
312: , gl_currency_code VARCHAR2(15)
313: , gl_set_of_books_id NUMBER

Line 310: , category_set_id mtl_stat_type_usages.category_set_id%TYPE

306: , start_date DATE
307: , end_date DATE
308: , conversion_option mtl_stat_type_usages.conversion_option%TYPE
309: , conversion_type mtl_stat_type_usages.conversion_type%TYPE
310: , category_set_id mtl_stat_type_usages.category_set_id%TYPE
311: , weight_uom_code mtl_stat_type_usages.weight_uom_code%TYPE
312: , gl_currency_code VARCHAR2(15)
313: , gl_set_of_books_id NUMBER
314: , gl_end_date DATE

Line 311: , weight_uom_code mtl_stat_type_usages.weight_uom_code%TYPE

307: , end_date DATE
308: , conversion_option mtl_stat_type_usages.conversion_option%TYPE
309: , conversion_type mtl_stat_type_usages.conversion_type%TYPE
310: , category_set_id mtl_stat_type_usages.category_set_id%TYPE
311: , weight_uom_code mtl_stat_type_usages.weight_uom_code%TYPE
312: , gl_currency_code VARCHAR2(15)
313: , gl_set_of_books_id NUMBER
314: , gl_end_date DATE
315: , gl_period_name VARCHAR2(15)

Line 316: , start_period_name mtl_stat_type_usages.start_period_name%TYPE

312: , gl_currency_code VARCHAR2(15)
313: , gl_set_of_books_id NUMBER
314: , gl_end_date DATE
315: , gl_period_name VARCHAR2(15)
316: , start_period_name mtl_stat_type_usages.start_period_name%TYPE
317: , end_period_name mtl_stat_type_usages.end_period_name%TYPE
318: , period_set_name mtl_stat_type_usages.period_set_name%TYPE
319: , period_type mtl_stat_type_usages.period_type%TYPE
320: , attribute_rule_set_code

Line 317: , end_period_name mtl_stat_type_usages.end_period_name%TYPE

313: , gl_set_of_books_id NUMBER
314: , gl_end_date DATE
315: , gl_period_name VARCHAR2(15)
316: , start_period_name mtl_stat_type_usages.start_period_name%TYPE
317: , end_period_name mtl_stat_type_usages.end_period_name%TYPE
318: , period_set_name mtl_stat_type_usages.period_set_name%TYPE
319: , period_type mtl_stat_type_usages.period_type%TYPE
320: , attribute_rule_set_code
321: mtl_stat_type_usages.attribute_rule_set_code%TYPE

Line 318: , period_set_name mtl_stat_type_usages.period_set_name%TYPE

314: , gl_end_date DATE
315: , gl_period_name VARCHAR2(15)
316: , start_period_name mtl_stat_type_usages.start_period_name%TYPE
317: , end_period_name mtl_stat_type_usages.end_period_name%TYPE
318: , period_set_name mtl_stat_type_usages.period_set_name%TYPE
319: , period_type mtl_stat_type_usages.period_type%TYPE
320: , attribute_rule_set_code
321: mtl_stat_type_usages.attribute_rule_set_code%TYPE
322: , alt_uom_rule_set_code

Line 319: , period_type mtl_stat_type_usages.period_type%TYPE

315: , gl_period_name VARCHAR2(15)
316: , start_period_name mtl_stat_type_usages.start_period_name%TYPE
317: , end_period_name mtl_stat_type_usages.end_period_name%TYPE
318: , period_set_name mtl_stat_type_usages.period_set_name%TYPE
319: , period_type mtl_stat_type_usages.period_type%TYPE
320: , attribute_rule_set_code
321: mtl_stat_type_usages.attribute_rule_set_code%TYPE
322: , alt_uom_rule_set_code
323: mtl_stat_type_usages.alt_uom_rule_set_code%TYPE

Line 321: mtl_stat_type_usages.attribute_rule_set_code%TYPE

317: , end_period_name mtl_stat_type_usages.end_period_name%TYPE
318: , period_set_name mtl_stat_type_usages.period_set_name%TYPE
319: , period_type mtl_stat_type_usages.period_type%TYPE
320: , attribute_rule_set_code
321: mtl_stat_type_usages.attribute_rule_set_code%TYPE
322: , alt_uom_rule_set_code
323: mtl_stat_type_usages.alt_uom_rule_set_code%TYPE
324: , triangulation_mode mtl_stat_type_usages.triangulation_mode%TYPE
325: , reference_period_rule mtl_stat_type_usages.reference_period_rule%TYPE

Line 323: mtl_stat_type_usages.alt_uom_rule_set_code%TYPE

319: , period_type mtl_stat_type_usages.period_type%TYPE
320: , attribute_rule_set_code
321: mtl_stat_type_usages.attribute_rule_set_code%TYPE
322: , alt_uom_rule_set_code
323: mtl_stat_type_usages.alt_uom_rule_set_code%TYPE
324: , triangulation_mode mtl_stat_type_usages.triangulation_mode%TYPE
325: , reference_period_rule mtl_stat_type_usages.reference_period_rule%TYPE
326: , pending_invoice_days mtl_stat_type_usages.pending_invoice_days%TYPE
327: , prior_invoice_days mtl_stat_type_usages.prior_invoice_days%TYPE

Line 324: , triangulation_mode mtl_stat_type_usages.triangulation_mode%TYPE

320: , attribute_rule_set_code
321: mtl_stat_type_usages.attribute_rule_set_code%TYPE
322: , alt_uom_rule_set_code
323: mtl_stat_type_usages.alt_uom_rule_set_code%TYPE
324: , triangulation_mode mtl_stat_type_usages.triangulation_mode%TYPE
325: , reference_period_rule mtl_stat_type_usages.reference_period_rule%TYPE
326: , pending_invoice_days mtl_stat_type_usages.pending_invoice_days%TYPE
327: , prior_invoice_days mtl_stat_type_usages.prior_invoice_days%TYPE
328: , returns_processing mtl_stat_type_usages.returns_processing%TYPE

Line 325: , reference_period_rule mtl_stat_type_usages.reference_period_rule%TYPE

321: mtl_stat_type_usages.attribute_rule_set_code%TYPE
322: , alt_uom_rule_set_code
323: mtl_stat_type_usages.alt_uom_rule_set_code%TYPE
324: , triangulation_mode mtl_stat_type_usages.triangulation_mode%TYPE
325: , reference_period_rule mtl_stat_type_usages.reference_period_rule%TYPE
326: , pending_invoice_days mtl_stat_type_usages.pending_invoice_days%TYPE
327: , prior_invoice_days mtl_stat_type_usages.prior_invoice_days%TYPE
328: , returns_processing mtl_stat_type_usages.returns_processing%TYPE
329: , kit_method mtl_stat_type_usages.kit_method%TYPE

Line 326: , pending_invoice_days mtl_stat_type_usages.pending_invoice_days%TYPE

322: , alt_uom_rule_set_code
323: mtl_stat_type_usages.alt_uom_rule_set_code%TYPE
324: , triangulation_mode mtl_stat_type_usages.triangulation_mode%TYPE
325: , reference_period_rule mtl_stat_type_usages.reference_period_rule%TYPE
326: , pending_invoice_days mtl_stat_type_usages.pending_invoice_days%TYPE
327: , prior_invoice_days mtl_stat_type_usages.prior_invoice_days%TYPE
328: , returns_processing mtl_stat_type_usages.returns_processing%TYPE
329: , kit_method mtl_stat_type_usages.kit_method%TYPE
330: , include_establishments mtl_stat_type_usages.include_establishments%TYPE

Line 327: , prior_invoice_days mtl_stat_type_usages.prior_invoice_days%TYPE

323: mtl_stat_type_usages.alt_uom_rule_set_code%TYPE
324: , triangulation_mode mtl_stat_type_usages.triangulation_mode%TYPE
325: , reference_period_rule mtl_stat_type_usages.reference_period_rule%TYPE
326: , pending_invoice_days mtl_stat_type_usages.pending_invoice_days%TYPE
327: , prior_invoice_days mtl_stat_type_usages.prior_invoice_days%TYPE
328: , returns_processing mtl_stat_type_usages.returns_processing%TYPE
329: , kit_method mtl_stat_type_usages.kit_method%TYPE
330: , include_establishments mtl_stat_type_usages.include_establishments%TYPE
331: );

Line 328: , returns_processing mtl_stat_type_usages.returns_processing%TYPE

324: , triangulation_mode mtl_stat_type_usages.triangulation_mode%TYPE
325: , reference_period_rule mtl_stat_type_usages.reference_period_rule%TYPE
326: , pending_invoice_days mtl_stat_type_usages.pending_invoice_days%TYPE
327: , prior_invoice_days mtl_stat_type_usages.prior_invoice_days%TYPE
328: , returns_processing mtl_stat_type_usages.returns_processing%TYPE
329: , kit_method mtl_stat_type_usages.kit_method%TYPE
330: , include_establishments mtl_stat_type_usages.include_establishments%TYPE
331: );
332:

Line 329: , kit_method mtl_stat_type_usages.kit_method%TYPE

325: , reference_period_rule mtl_stat_type_usages.reference_period_rule%TYPE
326: , pending_invoice_days mtl_stat_type_usages.pending_invoice_days%TYPE
327: , prior_invoice_days mtl_stat_type_usages.prior_invoice_days%TYPE
328: , returns_processing mtl_stat_type_usages.returns_processing%TYPE
329: , kit_method mtl_stat_type_usages.kit_method%TYPE
330: , include_establishments mtl_stat_type_usages.include_establishments%TYPE
331: );
332:
333:

Line 330: , include_establishments mtl_stat_type_usages.include_establishments%TYPE

326: , pending_invoice_days mtl_stat_type_usages.pending_invoice_days%TYPE
327: , prior_invoice_days mtl_stat_type_usages.prior_invoice_days%TYPE
328: , returns_processing mtl_stat_type_usages.returns_processing%TYPE
329: , kit_method mtl_stat_type_usages.kit_method%TYPE
330: , include_establishments mtl_stat_type_usages.include_establishments%TYPE
331: );
332:
333:
334: -- Declare the REF Cursor