DBA Data[Home] [Help]

APPS.INV_UOM_API_PUB dependencies on DUAL

Line 1827: FROM dual

1823:
1824: CURSOR GET_NON_BATCH_TXNS
1825: IS
1826: SELECT 1
1827: FROM dual
1828: WHERE EXISTS
1829: (SELECT mtln.transaction_id
1830: FROM mtl_transaction_lot_numbers mtln,
1831: mtl_material_transactions mmt

Line 2611: -- Error if the item is not Dual Fixed or dual default.

2607: FND_MSG_PUB.ADD;
2608:
2609: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2610: FND_MESSAGE.RAISE_ERROR;
2611: -- Error if the item is not Dual Fixed or dual default.
2612: ELSIF (L_SECONDARY_DEF_IND NOT IN ('F', 'D')) THEN
2613:
2614: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_TYPE3_ERROR');
2615: FND_MSG_PUB.ADD;

Line 3093: FROM FND_DUAL;

3089: IF p_action_type = 'I' THEN
3090:
3091: SELECT MTL_CONVERSION_ID_S.NEXTVAL
3092: INTO L_CONVERSION_ID
3093: FROM FND_DUAL;
3094:
3095: -- populating conversion pl-sql table.
3096: L_CONV_REC.CONVERSION_ID := L_CONVERSION_ID;
3097: