DBA Data[Home] [Help]

APPS.CSD_HVR_BI_PVT dependencies on DBMS_MVIEW

Line 42: DBMS_MVIEW.refresh(list => 'CSD_RO_PER_ITEM_MV',

38: BEGIN
39:
40: -- refresh the mviews for the HVR Execution that
41: -- are required for "Most Common Materials/Resources"
42: DBMS_MVIEW.refresh(list => 'CSD_RO_PER_ITEM_MV',
43: method => p_method
44: -- method => '?'
45: -- rollback_seg := NULL,
46: -- push_deferred_rpc := TRUE,

Line 54: DBMS_MVIEW.refresh(list => 'CSD_WIP_MTL_USED_MV',

50: -- heap_size := 0,
51: -- atomic_refresh := TRUE
52: );
53:
54: DBMS_MVIEW.refresh(list => 'CSD_WIP_MTL_USED_MV',
55: method => p_method
56: -- method => '?'
57: -- rollback_seg := NULL,
58: -- push_deferred_rpc := TRUE,

Line 66: dBMS_MVIEW.refresh(list => 'CSD_WIP_RES_USED_MV',

62: -- heap_size := 0,
63: -- atomic_refresh := TRUE
64: );
65:
66: dBMS_MVIEW.refresh(list => 'CSD_WIP_RES_USED_MV',
67: method => p_method
68: -- method => '?'
69: -- rollback_seg := NULL,
70: -- push_deferred_rpc := TRUE,

Line 83: DBMS_MVIEW.refresh(list => 'CSD_DC_FREQ_SUM_MV',

79: -- recommendations;required for "Frequency"
80: -- The following mviews refresh is dependent
81: -- on the refresh above (CSD_RO_PER_ITEM_MV)
82: -- DO NOT reorder the refresh sequence.
83: DBMS_MVIEW.refresh(list => 'CSD_DC_FREQ_SUM_MV',
84: method => p_method
85: -- method => '?'
86: -- rollback_seg := NULL,
87: -- push_deferred_rpc := TRUE,

Line 95: DBMS_MVIEW.refresh(list => 'CSD_SC_FREQ_SUM_MV',

91: -- heap_size := 0,
92: -- atomic_refresh := TRUE
93: );
94:
95: DBMS_MVIEW.refresh(list => 'CSD_SC_FREQ_SUM_MV',
96: method => p_method
97: -- method => '?'
98: -- rollback_seg := NULL,
99: -- push_deferred_rpc := TRUE,