APPS.OPI_DBI_WMS_STORAGE_UTZ_PKG dependencies on STANDARD

Line 16: -- Package level variables for the standard who columns

12: s_opi_schema VARCHAR2(30);
13: s_status VARCHAR2(30);
14: s_industry VARCHAR2(30);
15:
16: -- Package level variables for the standard who columns
17: s_user_id NUMBER;
18: s_login_id NUMBER;
19: s_program_id NUMBER;
20: s_program_login_id NUMBER;

Line 744: -- the standard conversion rates table, OPI_DBI_REP_UOM_STD_CONV_F.

740: -- item weight/volume before a value is specified. So no need to
741: -- worry about missing UOMs and specified values.
742: --
743: -- All possible conversions to the reporting UOMs are stored in
744: -- the standard conversion rates table, OPI_DBI_REP_UOM_STD_CONV_F.
745: -- The extraction program will join twice to this table, once
746: -- for weight conversions and once for volume conversions.
747: -- Since certain rows may not join to the conversion fact for
748: -- one of the measures, use outer joins.

Line 783: -- joins to the standard conversion rates tables based on these

779: -- nothing from Kg --> M3. To avoid filtering out rows for such
780: -- items and instead reporting errors for them, this SQL has
781: -- to be written with an inline view which contains all the
782: -- from and reporting UOMs, and an outer SQL that purely outer
783: -- joins to the standard conversion rates tables based on these
784: -- from and reporting UOMs.
785: --
786: INSERT /*+ append parallel (opi_dbi_wms_stor_item_conv_f) */
787: INTO opi_dbi_wms_stor_item_conv_f (

Line 1283: -- the standard conversion rates table, OPI_DBI_REP_UOM_STD_CONV_F.

1279: -- item weight/volume before a value is specified. So no need to
1280: -- worry about missing UOMs and specified values.
1281: --
1282: -- All possible conversions to the reporting UOMs are stored in
1283: -- the standard conversion rates table, OPI_DBI_REP_UOM_STD_CONV_F.
1284: -- The extraction program will join twice to this table, once
1285: -- for weight conversions and once for volume conversions.
1286: -- Since certain rows may not join to the conversion fact for
1287: -- one of the measures, use outer joins.

Line 1322: -- joins to the standard conversion rates tables based on these

1318: -- nothing from Kg --> M3. To avoid filtering out rows for such
1319: -- items and instead reporting errors for them, this SQL has
1320: -- to be written with an inline view which contains all the
1321: -- from and reporting UOMs, and an outer SQL that purely outer
1322: -- joins to the standard conversion rates tables based on these
1323: -- from and reporting UOMs.
1324: --
1325: --
1326: -- It seems like overkill to compute conversion rates for all