APPS.OPI_DBI_WMS_CAPACITY_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 660: -- the standard conversion rates table, OPI_DBI_REP_UOM_STD_CONV_F.

656: -- The locator weight capacity, volume_capacity, weight_uom_code
657: -- and volume_uom_code are stored in the MTL_ITEM_LOCATIONS table.
658: --
659: -- All possible conversions to the reporting UOMs are stored in
660: -- the standard conversion rates table, OPI_DBI_REP_UOM_STD_CONV_F.
661: -- The extraction program will join twice to this table, once
662: -- for weight capacity conversions and once for volume capacity
663: -- conversions. Since certain rows may not join to the conversion
664: -- fact for one of the measures, use outer joins.

Line 689: -- rates will be negative in the standard conversion rates table,

685: -- Either of the two above are error conditions and the corresponding
686: -- capacities must therefore be flagged with a -1 so that it can be
687: -- reported.
688: -- The above conditions are detectable as the corresponding conversion
689: -- rates will be negative in the standard conversion rates table,
690: -- OPI_DBI_REP_UOM_STD_CONV_F.
691: --
692: -- Missing Reporting UOMs:
693: -- 1. The Weight Reporting UOM can be missing.

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

705: -- nothing from Kg --> M3. To avoid filtering out rows for such
706: -- locators and instead reporting errors for them, this SQL has
707: -- to be written with an inline view which contains all the
708: -- from and reporting UOMs, and an outer SQL that purely outer
709: -- joins to the standard conversion rates tables based on these
710: -- from and reporting UOMs.
711: --
712: INSERT /*+ append */
713: INTO opi_dbi_wms_curr_utz_sub_stg (

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

1153: -- 1 - Organization, Inventory Category, Subinventory
1154: -- 0 - Organization, Inventory Category, Subinventory, Item
1155: --
1156: -- All possible conversions to the reporting UOMs are stored in
1157: -- the standard conversion rates table, OPI_DBI_REP_UOM_STD_CONV_F.
1158: -- The extraction program will join twice to this table, once
1159: -- for weight capacity conversions and once for volume capacity
1160: -- conversions. Since certain rows may not join to the conversion
1161: -- fact for one of the measures, use outer joins.

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

1200: -- nothing from Kg --> M3. To avoid filtering out rows for such
1201: -- items and instead reporting errors for them, this SQL has
1202: -- to be written with an inline view which contains all the
1203: -- from and reporting UOMs, and an outer SQL that purely outer
1204: -- joins to the standard conversion rates tables based on these
1205: -- from and reporting UOMs.
1206: --
1207: INSERT /*+ append */
1208: INTO opi_dbi_wms_curr_utz_item_f (