APPS.INV_GMI_MIGRATION dependencies on DUAL

Line 840: FROM DUAL;

836: END IF;
837:
838: SELECT mtl_material_status_s.NEXTVAL
839: INTO l_status_id
840: FROM DUAL;
841:
842: l_availability_type := 2;
843: IF (l_lot_status.rejected_ind = 0) THEN
844: IF (l_lot_status.nettable_ind = 1) THEN

Line 1700: SELECT MTL_CONVERSION_ID_S.NEXTVAL INTO l_conversion_id FROM DUAL;

1696: p_app_short_name => 'GMI');
1697: raise FND_API.G_EXC_ERROR;
1698: END IF;
1699:
1700: SELECT MTL_CONVERSION_ID_S.NEXTVAL INTO l_conversion_id FROM DUAL;
1701:
1702: INSERT INTO mtl_lot_uom_class_conversions(
1703: conversion_id,
1704: lot_number,

Line 1745: INTO l_conv_audit_id FROM DUAL;

1741:
1742: FOR cuadit in c_gmi_item_conv_audit(c.conversion_id) LOOP
1743:
1744: SELECT MTL_CONV_AUDIT_ID_S.NEXTVAL
1745: INTO l_conv_audit_id FROM DUAL;
1746:
1747: l_field_name := 'Reason Id';
1748: l_field_value := 'Reason Code = ' || cuadit.reason_code;
1749:

Line 1825: FROM dual;

1821: l_locator_id := NULL;
1822: IF (G_DEFAULT_LOCT is NULL) THEN
1823: SELECT fnd_profile.value ('IC$DEFAULT_LOCT')
1824: INTO G_DEFAULT_LOCT
1825: FROM dual;
1826: END IF;
1827: IF (adetail.location <> G_DEFAULT_LOCT) THEN
1828: BEGIN
1829: SELECT locator_id INTO l_locator_id

Line 1908: INTO l_conv_audit_detail_id FROM DUAL;

1904: END;
1905: END IF;
1906:
1907: SELECT MTL_CONV_AUDIT_DETAIL_ID_S.NEXTVAL
1908: INTO l_conv_audit_detail_id FROM DUAL;
1909: INSERT INTO mtl_lot_conv_audit_details(
1910: conv_audit_detail_id,
1911: conv_audit_id,
1912: revision,

Line 2074: FROM dual

2070: 0,
2071: sysdate,
2072: 0,
2073: 0
2074: FROM dual
2075: WHERE
2076: NOT EXISTS (
2077: SELECT 1
2078: FROM sy_docs_seq

Line 2547: FROM dual;

2543: l_subinventory_code := NULL;
2544: IF (G_DEFAULT_LOCT is NULL) THEN
2545: SELECT fnd_profile.value ('IC$DEFAULT_LOCT')
2546: INTO G_DEFAULT_LOCT
2547: FROM dual;
2548: END IF;
2549: IF ( l_whse_loct_ctl <> 0 and l_item_loct_ctl <> 0 and
2550: bal.location <> G_DEFAULT_LOCT) THEN
2551: BEGIN