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 1163: l_dual_uom_dev_low_col VARCHAR2(50);

1159: l_lifecycle_phase_col_val VARCHAR2(50);
1160: --Bug: 3969593 Adding new 11.5.10 Primary Attrs: Begin
1161: l_conversions_col VARCHAR2(50);
1162: l_secondary_def_col VARCHAR2(50);
1163: l_dual_uom_dev_low_col VARCHAR2(50);
1164: l_dual_uom_dev_high_col VARCHAR2(50);
1165: l_ont_pricing_qty_src_col VARCHAR2(50);
1166: l_secondary_uom_code_col VARCHAR2(50);
1167: l_tracking_qty_ind_col VARCHAR2(50);

Line 1164: l_dual_uom_dev_high_col VARCHAR2(50);

1160: --Bug: 3969593 Adding new 11.5.10 Primary Attrs: Begin
1161: l_conversions_col VARCHAR2(50);
1162: l_secondary_def_col VARCHAR2(50);
1163: l_dual_uom_dev_low_col VARCHAR2(50);
1164: l_dual_uom_dev_high_col VARCHAR2(50);
1165: l_ont_pricing_qty_src_col VARCHAR2(50);
1166: l_secondary_uom_code_col VARCHAR2(50);
1167: l_tracking_qty_ind_col VARCHAR2(50);
1168: --Bug: 3969593 End

Line 1317: ELSIF (l_prod_col_name = G_DUAL_UOM_DEV_LOW) THEN

1313: ELSIF (l_prod_col_name = G_CONVERSIONS) THEN
1314: l_conversions_col := l_intf_col_name;
1315: ELSIF (l_prod_col_name = G_SECONDARY_DEF_IND) THEN
1316: l_secondary_def_col := l_intf_col_name;
1317: ELSIF (l_prod_col_name = G_DUAL_UOM_DEV_LOW) THEN
1318: l_dual_uom_dev_low_col := l_intf_col_name;
1319: ELSIF (l_prod_col_name = G_DUAL_UOM_DEV_HIGH) THEN
1320: l_dual_uom_dev_high_col := l_intf_col_name;
1321: ELSIF (l_prod_col_name = G_ONT_PRICING_QTY_SRC) THEN

Line 1318: l_dual_uom_dev_low_col := l_intf_col_name;

1314: l_conversions_col := l_intf_col_name;
1315: ELSIF (l_prod_col_name = G_SECONDARY_DEF_IND) THEN
1316: l_secondary_def_col := l_intf_col_name;
1317: ELSIF (l_prod_col_name = G_DUAL_UOM_DEV_LOW) THEN
1318: l_dual_uom_dev_low_col := l_intf_col_name;
1319: ELSIF (l_prod_col_name = G_DUAL_UOM_DEV_HIGH) THEN
1320: l_dual_uom_dev_high_col := l_intf_col_name;
1321: ELSIF (l_prod_col_name = G_ONT_PRICING_QTY_SRC) THEN
1322: l_ont_pricing_qty_src_col := l_intf_col_name;

Line 1319: ELSIF (l_prod_col_name = G_DUAL_UOM_DEV_HIGH) THEN

1315: ELSIF (l_prod_col_name = G_SECONDARY_DEF_IND) THEN
1316: l_secondary_def_col := l_intf_col_name;
1317: ELSIF (l_prod_col_name = G_DUAL_UOM_DEV_LOW) THEN
1318: l_dual_uom_dev_low_col := l_intf_col_name;
1319: ELSIF (l_prod_col_name = G_DUAL_UOM_DEV_HIGH) THEN
1320: l_dual_uom_dev_high_col := l_intf_col_name;
1321: ELSIF (l_prod_col_name = G_ONT_PRICING_QTY_SRC) THEN
1322: l_ont_pricing_qty_src_col := l_intf_col_name;
1323: ELSIF (l_prod_col_name = G_SECONDARY_UOM_CODE) THEN

Line 1320: l_dual_uom_dev_high_col := l_intf_col_name;

1316: l_secondary_def_col := l_intf_col_name;
1317: ELSIF (l_prod_col_name = G_DUAL_UOM_DEV_LOW) THEN
1318: l_dual_uom_dev_low_col := l_intf_col_name;
1319: ELSIF (l_prod_col_name = G_DUAL_UOM_DEV_HIGH) THEN
1320: l_dual_uom_dev_high_col := l_intf_col_name;
1321: ELSIF (l_prod_col_name = G_ONT_PRICING_QTY_SRC) THEN
1322: l_ont_pricing_qty_src_col := l_intf_col_name;
1323: ELSIF (l_prod_col_name = G_SECONDARY_UOM_CODE) THEN
1324: l_secondary_uom_code_col := l_intf_col_name;

Line 1755: FROM dual;

1751: -----------------------------------------------------------------
1752: IF p_set_process_id IS NULL THEN
1753: SELECT mtl_system_items_intf_sets_s.NEXTVAL
1754: INTO l_msii_set_process_id
1755: FROM dual;
1756: ELSE
1757: l_msii_set_process_id := p_set_process_id;
1758: END IF;
1759:

Line 3662: FROM dual;

3658: -----------------------------------------------------------------
3659: IF p_set_process_id IS NULL THEN
3660: SELECT mtl_system_items_intf_sets_s.NEXTVAL
3661: INTO l_msii_set_process_id
3662: FROM dual;
3663: ELSE
3664: l_msii_set_process_id := p_set_process_id;
3665: END IF;
3666:

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

6833: IF ( length(l_leafAttrs_bTable_dbCol) > 0 ) THEN
6834:
6835: EXECUTE IMMEDIATE ' UPDATE EGO_ITEM_GTN_ATTRS_B SET ( '|| l_leafAttrs_bTable_dbCol ||
6836: ' ) = ( SELECT '|| l_leafAttrs_bTable_value ||
6837: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id '||
6838: ' AND ORGANIZATION_ID = :organization_id ' USING l_inventory_item_id , l_organization_id;
6839:
6840: END IF;
6841:

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

6842: IF ( length(l_leafAttrs_tlTable_dbCol) > 0 ) THEN
6843:
6844: EXECUTE IMMEDIATE ' UPDATE EGO_ITEM_GTN_ATTRS_TL SET ( '|| l_leafAttrs_tlTable_dbCol ||
6845: ' ) = ( SELECT '|| l_leafAttrs_tlTable_value ||
6846: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id ' ||
6847: ' AND ORGANIZATION_ID = :organization_id ' USING l_inventory_item_id , l_organization_id;
6848: END IF;
6849:
6850: IF ( length(l_leafAttrs_MulBTable_dbCol) > 0 ) THEN

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

6850: IF ( length(l_leafAttrs_MulBTable_dbCol) > 0 ) THEN
6851:
6852: EXECUTE IMMEDIATE ' UPDATE EGO_ITM_GTN_MUL_ATTRS_B SET ( ' || l_leafAttrs_MulBTable_dbCol||
6853: ' ) = ( SELECT ' || l_leafAttrs_MulBTable_value ||
6854: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id ' ||
6855: ' AND ORGANIZATION_ID = :organization_id ' USING l_inventory_item_id , l_organization_id;
6856: END IF;
6857: IF ( length(l_leafAttrs_MultlTable_dbCol) > 0 ) THEN
6858: EXECUTE IMMEDIATE ' UPDATE EGO_ITM_GTN_MUL_ATTRS_TL SET ( ' || l_leafAttrs_MultlTable_dbCol||

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

6856: END IF;
6857: IF ( length(l_leafAttrs_MultlTable_dbCol) > 0 ) THEN
6858: EXECUTE IMMEDIATE ' UPDATE EGO_ITM_GTN_MUL_ATTRS_TL SET ( ' || l_leafAttrs_MultlTable_dbCol||
6859: ' ) = ( SELECT ' || l_leafAttrs_MultlTable_value ||
6860: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id' ||
6861: ' AND ORGANIZATION_ID = :organization_id ' USING l_inventory_item_id , l_organization_id;
6862: END IF;
6863:
6864: EGO_GTIN_PVT.UPDATE_REG_PUB_UPDATE_DATES (p_inventory_item_id => l_inventory_item_id ,

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

6877: IF ( length(l_rootAttrs_bTable_dbCol) > 0 ) THEN
6878:
6879: EXECUTE IMMEDIATE ' UPDATE EGO_ITEM_GTN_ATTRS_B SET ( '|| l_rootAttrs_bTable_dbCol ||
6880: ' ) = ( SELECT'|| l_rootAttrs_bTable_value ||
6881: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id '||
6882: ' AND ORGANIZATION_ID = :organization_id ' USING l_inventory_item_id , l_organization_id;
6883: END IF;
6884: IF ( length(l_rootAttrs_tlTable_dbCol) > 0 ) THEN
6885:

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

6884: IF ( length(l_rootAttrs_tlTable_dbCol) > 0 ) THEN
6885:
6886: EXECUTE IMMEDIATE ' UPDATE EGO_ITEM_GTN_ATTRS_TL SET ( '|| l_rootAttrs_tlTable_dbCol ||
6887: ' ) = ( SELECT'|| l_rootAttrs_tlTable_value ||
6888: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id ' ||
6889: ' AND ORGANIZATION_ID = :organization_id ' USING l_inventory_item_id , l_organization_id;
6890: END IF;
6891: IF ( length(l_rootAttrs_MulBTable_dbCol) > 0 ) THEN
6892:

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

6891: IF ( length(l_rootAttrs_MulBTable_dbCol) > 0 ) THEN
6892:
6893: EXECUTE IMMEDIATE ' UPDATE EGO_ITM_GTN_MUL_ATTRS_B SET ( '|| l_rootAttrs_MulBTable_dbCol ||
6894: ' ) = ( SELECT '|| l_rootAttrs_MulBTable_value ||
6895: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id ' ||
6896: ' AND ORGANIZATION_ID = :organization_id ' USING l_inventory_item_id , l_organization_id;
6897: END IF;
6898: IF ( length(l_rootAttrs_MultlTable_dbCol) > 0 ) THEN
6899:

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

6898: IF ( length(l_rootAttrs_MultlTable_dbCol) > 0 ) THEN
6899:
6900: EXECUTE IMMEDIATE ' UPDATE EGO_ITM_GTN_MUL_ATTRS_TL SET ( '||l_rootAttrs_MultlTable_dbCol ||
6901: ' ) = ( SELECT '|| l_rootAttrs_MultlTable_value ||
6902: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id ' ||
6903: ' AND ORGANIZATION_ID = :organization_id ' USING l_inventory_item_id , l_organization_id;
6904: END IF;
6905:
6906: EGO_GTIN_PVT.UPDATE_REG_PUB_UPDATE_DATES (p_inventory_item_id => l_inventory_item_id ,

Line 7317: FROM dual;

7313:
7314: IF p_set_process_id IS NULL THEN
7315: SELECT mtl_system_items_intf_sets_s.NEXTVAL
7316: INTO l_msii_set_process_id
7317: FROM dual;
7318: ELSE
7319: l_msii_set_process_id := p_set_process_id;
7320: END IF;
7321: