APPS.INV_GMI_MIGRATION dependencies on DUAL

Line 926: FROM DUAL;

922: END IF;
923:
924: SELECT mtl_material_status_s.NEXTVAL
925: INTO l_status_id
926: FROM DUAL;
927:
928: l_availability_type := 2;
929: IF (l_lot_status.rejected_ind = 0) THEN
930: IF (l_lot_status.nettable_ind = 1) THEN

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

1788: p_app_short_name => 'GMI');
1789: raise FND_API.G_EXC_ERROR;
1790: END IF;
1791:
1792: SELECT MTL_CONVERSION_ID_S.NEXTVAL INTO l_conversion_id FROM DUAL;
1793:
1794: INSERT INTO mtl_lot_uom_class_conversions(
1795: conversion_id,
1796: lot_number,

Line 1837: INTO l_conv_audit_id FROM DUAL;

1833:
1834: FOR cuadit in c_gmi_item_conv_audit(c.conversion_id) LOOP
1835:
1836: SELECT MTL_CONV_AUDIT_ID_S.NEXTVAL
1837: INTO l_conv_audit_id FROM DUAL;
1838:
1839: l_field_name := 'Reason Id';
1840: l_field_value := 'Reason Code = ' || cuadit.reason_code;
1841:

Line 1917: FROM dual;

1913: l_locator_id := NULL;
1914: IF (G_DEFAULT_LOCT is NULL) THEN
1915: SELECT fnd_profile.value ('IC$DEFAULT_LOCT')
1916: INTO G_DEFAULT_LOCT
1917: FROM dual;
1918: END IF;
1919: IF (adetail.location <> G_DEFAULT_LOCT) THEN
1920: BEGIN
1921: SELECT locator_id INTO l_locator_id

Line 2000: INTO l_conv_audit_detail_id FROM DUAL;

1996: END;
1997: END IF;
1998:
1999: SELECT MTL_CONV_AUDIT_DETAIL_ID_S.NEXTVAL
2000: INTO l_conv_audit_detail_id FROM DUAL;
2001: INSERT INTO mtl_lot_conv_audit_details(
2002: conv_audit_detail_id,
2003: conv_audit_id,
2004: revision,

Line 2169: FROM dual

2165: 0,
2166: sysdate,
2167: 0,
2168: 0
2169: FROM dual
2170: WHERE
2171: NOT EXISTS (
2172: SELECT 1
2173: FROM sy_docs_seq

Line 2662: FROM dual;

2658: l_subinventory_code := NULL;
2659: IF (G_DEFAULT_LOCT is NULL) THEN
2660: SELECT fnd_profile.value ('IC$DEFAULT_LOCT')
2661: INTO G_DEFAULT_LOCT
2662: FROM dual;
2663: END IF;
2664: IF ( l_whse_loct_ctl <> 0 and bal.item_loct_ctl <> 0 and
2665: bal.location <> G_DEFAULT_LOCT) THEN
2666: BEGIN