eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_ITEM_BULKLOAD_PKG dependencies on DUAL

Line 164: G_DUAL_UOM_DEV_LOW VARCHAR2(50) := 'DUAL_UOM_DEVIATION_LOW';

160: G_CREATION_DATE VARCHAR2(50) := 'CREATION_DATE';
161: --Bug: 3969593 Adding new 11.5.10 Primary Attrs: Begin
162: G_CONVERSIONS VARCHAR2(50) := 'ALLOWED_UNITS_LOOKUP_CODE';
163: G_SECONDARY_DEF_IND VARCHAR2(50) := 'SECONDARY_DEFAULT_IND';
164: G_DUAL_UOM_DEV_LOW VARCHAR2(50) := 'DUAL_UOM_DEVIATION_LOW';
165: G_DUAL_UOM_DEV_HIGH VARCHAR2(50) := 'DUAL_UOM_DEVIATION_HIGH';
166: G_ONT_PRICING_QTY_SRC VARCHAR2(50) := 'ONT_PRICING_QTY_SOURCE';
167: G_SECONDARY_UOM_CODE VARCHAR2(50) := 'SECONDARY_UOM_CODE';
168: G_TRACKING_QTY_IND VARCHAR2(50) := 'TRACKING_QUANTITY_IND';

Line 165: G_DUAL_UOM_DEV_HIGH VARCHAR2(50) := 'DUAL_UOM_DEVIATION_HIGH';

161: --Bug: 3969593 Adding new 11.5.10 Primary Attrs: Begin
162: G_CONVERSIONS VARCHAR2(50) := 'ALLOWED_UNITS_LOOKUP_CODE';
163: G_SECONDARY_DEF_IND VARCHAR2(50) := 'SECONDARY_DEFAULT_IND';
164: G_DUAL_UOM_DEV_LOW VARCHAR2(50) := 'DUAL_UOM_DEVIATION_LOW';
165: G_DUAL_UOM_DEV_HIGH VARCHAR2(50) := 'DUAL_UOM_DEVIATION_HIGH';
166: G_ONT_PRICING_QTY_SRC VARCHAR2(50) := 'ONT_PRICING_QTY_SOURCE';
167: G_SECONDARY_UOM_CODE VARCHAR2(50) := 'SECONDARY_UOM_CODE';
168: G_TRACKING_QTY_IND VARCHAR2(50) := 'TRACKING_QUANTITY_IND';
169: --Bug: 3969593 End

Line 1201: l_dual_uom_dev_low_col VARCHAR2(50);

1197: l_lifecycle_phase_col_val VARCHAR2(50);
1198: --Bug: 3969593 Adding new 11.5.10 Primary Attrs: Begin
1199: l_conversions_col VARCHAR2(50);
1200: l_secondary_def_col VARCHAR2(50);
1201: l_dual_uom_dev_low_col VARCHAR2(50);
1202: l_dual_uom_dev_high_col VARCHAR2(50);
1203: l_ont_pricing_qty_src_col VARCHAR2(50);
1204: l_secondary_uom_code_col VARCHAR2(50);
1205: l_tracking_qty_ind_col VARCHAR2(50);

Line 1202: l_dual_uom_dev_high_col VARCHAR2(50);

1198: --Bug: 3969593 Adding new 11.5.10 Primary Attrs: Begin
1199: l_conversions_col VARCHAR2(50);
1200: l_secondary_def_col VARCHAR2(50);
1201: l_dual_uom_dev_low_col VARCHAR2(50);
1202: l_dual_uom_dev_high_col VARCHAR2(50);
1203: l_ont_pricing_qty_src_col VARCHAR2(50);
1204: l_secondary_uom_code_col VARCHAR2(50);
1205: l_tracking_qty_ind_col VARCHAR2(50);
1206: --Bug: 3969593 End

Line 1359: ELSIF (l_prod_col_name = G_DUAL_UOM_DEV_LOW) THEN

1355: ELSIF (l_prod_col_name = G_CONVERSIONS) THEN
1356: l_conversions_col := l_intf_col_name;
1357: ELSIF (l_prod_col_name = G_SECONDARY_DEF_IND) THEN
1358: l_secondary_def_col := l_intf_col_name;
1359: ELSIF (l_prod_col_name = G_DUAL_UOM_DEV_LOW) THEN
1360: l_dual_uom_dev_low_col := l_intf_col_name;
1361: ELSIF (l_prod_col_name = G_DUAL_UOM_DEV_HIGH) THEN
1362: l_dual_uom_dev_high_col := l_intf_col_name;
1363: ELSIF (l_prod_col_name = G_ONT_PRICING_QTY_SRC) THEN

Line 1360: l_dual_uom_dev_low_col := l_intf_col_name;

1356: l_conversions_col := l_intf_col_name;
1357: ELSIF (l_prod_col_name = G_SECONDARY_DEF_IND) THEN
1358: l_secondary_def_col := l_intf_col_name;
1359: ELSIF (l_prod_col_name = G_DUAL_UOM_DEV_LOW) THEN
1360: l_dual_uom_dev_low_col := l_intf_col_name;
1361: ELSIF (l_prod_col_name = G_DUAL_UOM_DEV_HIGH) THEN
1362: l_dual_uom_dev_high_col := l_intf_col_name;
1363: ELSIF (l_prod_col_name = G_ONT_PRICING_QTY_SRC) THEN
1364: l_ont_pricing_qty_src_col := l_intf_col_name;

Line 1361: ELSIF (l_prod_col_name = G_DUAL_UOM_DEV_HIGH) THEN

1357: ELSIF (l_prod_col_name = G_SECONDARY_DEF_IND) THEN
1358: l_secondary_def_col := l_intf_col_name;
1359: ELSIF (l_prod_col_name = G_DUAL_UOM_DEV_LOW) THEN
1360: l_dual_uom_dev_low_col := l_intf_col_name;
1361: ELSIF (l_prod_col_name = G_DUAL_UOM_DEV_HIGH) THEN
1362: l_dual_uom_dev_high_col := l_intf_col_name;
1363: ELSIF (l_prod_col_name = G_ONT_PRICING_QTY_SRC) THEN
1364: l_ont_pricing_qty_src_col := l_intf_col_name;
1365: ELSIF (l_prod_col_name = G_SECONDARY_UOM_CODE) THEN

Line 1362: l_dual_uom_dev_high_col := l_intf_col_name;

1358: l_secondary_def_col := l_intf_col_name;
1359: ELSIF (l_prod_col_name = G_DUAL_UOM_DEV_LOW) THEN
1360: l_dual_uom_dev_low_col := l_intf_col_name;
1361: ELSIF (l_prod_col_name = G_DUAL_UOM_DEV_HIGH) THEN
1362: l_dual_uom_dev_high_col := l_intf_col_name;
1363: ELSIF (l_prod_col_name = G_ONT_PRICING_QTY_SRC) THEN
1364: l_ont_pricing_qty_src_col := l_intf_col_name;
1365: ELSIF (l_prod_col_name = G_SECONDARY_UOM_CODE) THEN
1366: l_secondary_uom_code_col := l_intf_col_name;

Line 1820: FROM dual;

1816: -----------------------------------------------------------------
1817: IF p_set_process_id IS NULL THEN
1818: SELECT mtl_system_items_intf_sets_s.NEXTVAL
1819: INTO l_msii_set_process_id
1820: FROM dual;
1821: ELSE
1822: l_msii_set_process_id := p_set_process_id;
1823: END IF;
1824:

Line 3747: FROM dual;

3743: -----------------------------------------------------------------
3744: IF p_set_process_id IS NULL THEN
3745: SELECT mtl_system_items_intf_sets_s.NEXTVAL
3746: INTO l_msii_set_process_id
3747: FROM dual;
3748: ELSE
3749: l_msii_set_process_id := p_set_process_id;
3750: END IF;
3751:

Line 6990: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id '||

6986: IF ( length(l_leafAttrs_bTable_dbCol) > 0 ) THEN
6987:
6988: EXECUTE IMMEDIATE ' UPDATE EGO_ITEM_GTN_ATTRS_B SET ( '|| l_leafAttrs_bTable_dbCol ||
6989: ' ) = ( SELECT '|| l_leafAttrs_bTable_value ||
6990: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id '||
6991: ' AND ORGANIZATION_ID = :organization_id ' USING l_inventory_item_id , l_organization_id;
6992:
6993: END IF;
6994:

Line 6999: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id ' ||

6995: IF ( length(l_leafAttrs_tlTable_dbCol) > 0 ) THEN
6996:
6997: EXECUTE IMMEDIATE ' UPDATE EGO_ITEM_GTN_ATTRS_TL SET ( '|| l_leafAttrs_tlTable_dbCol ||
6998: ' ) = ( SELECT '|| l_leafAttrs_tlTable_value ||
6999: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id ' ||
7000: ' AND ORGANIZATION_ID = :organization_id ' USING l_inventory_item_id , l_organization_id;
7001: END IF;
7002:
7003: IF ( length(l_leafAttrs_MulBTable_dbCol) > 0 ) THEN

Line 7007: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id ' ||

7003: IF ( length(l_leafAttrs_MulBTable_dbCol) > 0 ) THEN
7004:
7005: EXECUTE IMMEDIATE ' UPDATE EGO_ITM_GTN_MUL_ATTRS_B SET ( ' || l_leafAttrs_MulBTable_dbCol||
7006: ' ) = ( SELECT ' || l_leafAttrs_MulBTable_value ||
7007: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id ' ||
7008: ' AND ORGANIZATION_ID = :organization_id ' USING l_inventory_item_id , l_organization_id;
7009: END IF;
7010: IF ( length(l_leafAttrs_MultlTable_dbCol) > 0 ) THEN
7011: EXECUTE IMMEDIATE ' UPDATE EGO_ITM_GTN_MUL_ATTRS_TL SET ( ' || l_leafAttrs_MultlTable_dbCol||

Line 7013: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id' ||

7009: END IF;
7010: IF ( length(l_leafAttrs_MultlTable_dbCol) > 0 ) THEN
7011: EXECUTE IMMEDIATE ' UPDATE EGO_ITM_GTN_MUL_ATTRS_TL SET ( ' || l_leafAttrs_MultlTable_dbCol||
7012: ' ) = ( SELECT ' || l_leafAttrs_MultlTable_value ||
7013: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id' ||
7014: ' AND ORGANIZATION_ID = :organization_id ' USING l_inventory_item_id , l_organization_id;
7015: END IF;
7016:
7017: EGO_GTIN_PVT.UPDATE_REG_PUB_UPDATE_DATES (p_inventory_item_id => l_inventory_item_id ,

Line 7034: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id '||

7030: IF ( length(l_rootAttrs_bTable_dbCol) > 0 ) THEN
7031:
7032: EXECUTE IMMEDIATE ' UPDATE EGO_ITEM_GTN_ATTRS_B SET ( '|| l_rootAttrs_bTable_dbCol ||
7033: ' ) = ( SELECT'|| l_rootAttrs_bTable_value ||
7034: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id '||
7035: ' AND ORGANIZATION_ID = :organization_id ' USING l_inventory_item_id , l_organization_id;
7036: END IF;
7037: IF ( length(l_rootAttrs_tlTable_dbCol) > 0 ) THEN
7038:

Line 7041: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id ' ||

7037: IF ( length(l_rootAttrs_tlTable_dbCol) > 0 ) THEN
7038:
7039: EXECUTE IMMEDIATE ' UPDATE EGO_ITEM_GTN_ATTRS_TL SET ( '|| l_rootAttrs_tlTable_dbCol ||
7040: ' ) = ( SELECT'|| l_rootAttrs_tlTable_value ||
7041: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id ' ||
7042: ' AND ORGANIZATION_ID = :organization_id ' USING l_inventory_item_id , l_organization_id;
7043: END IF;
7044: IF ( length(l_rootAttrs_MulBTable_dbCol) > 0 ) THEN
7045:

Line 7048: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id ' ||

7044: IF ( length(l_rootAttrs_MulBTable_dbCol) > 0 ) THEN
7045:
7046: EXECUTE IMMEDIATE ' UPDATE EGO_ITM_GTN_MUL_ATTRS_B SET ( '|| l_rootAttrs_MulBTable_dbCol ||
7047: ' ) = ( SELECT '|| l_rootAttrs_MulBTable_value ||
7048: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id ' ||
7049: ' AND ORGANIZATION_ID = :organization_id ' USING l_inventory_item_id , l_organization_id;
7050: END IF;
7051: IF ( length(l_rootAttrs_MultlTable_dbCol) > 0 ) THEN
7052:

Line 7055: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id ' ||

7051: IF ( length(l_rootAttrs_MultlTable_dbCol) > 0 ) THEN
7052:
7053: EXECUTE IMMEDIATE ' UPDATE EGO_ITM_GTN_MUL_ATTRS_TL SET ( '||l_rootAttrs_MultlTable_dbCol ||
7054: ' ) = ( SELECT '|| l_rootAttrs_MultlTable_value ||
7055: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id ' ||
7056: ' AND ORGANIZATION_ID = :organization_id ' USING l_inventory_item_id , l_organization_id;
7057: END IF;
7058:
7059: EGO_GTIN_PVT.UPDATE_REG_PUB_UPDATE_DATES (p_inventory_item_id => l_inventory_item_id ,

Line 7470: FROM dual;

7466:
7467: IF p_set_process_id IS NULL THEN
7468: SELECT mtl_system_items_intf_sets_s.NEXTVAL
7469: INTO l_msii_set_process_id
7470: FROM dual;
7471: ELSE
7472: l_msii_set_process_id := p_set_process_id;
7473: END IF;
7474: