DBA Data[Home] [Help]

APPS.CST_INVENTORY_PVT dependencies on DUAL

Line 524: FROM dual

520: */
521: UNION
522: SELECT p_organization_id,
523: 1
524: FROM dual
525: ) CCGA
526: WHERE CCGA.organization_id = p_organization_id
527: AND CCG.cost_group_id = CCGA.cost_group_id
528: AND NVL(CCG.disable_date, sysdate+1) > sysdate

Line 580: FROM dual

576: */
577: UNION
578: SELECT p_organization_id,
579: 1
580: FROM dual
581: ) CCGA,
582: mtl_interorg_parameters MIP
583: WHERE CCG.cost_group_id = CCGA.cost_group_id
584: AND NVL(CCG.disable_date, sysdate+1) > sysdate

Line 4171: -- FROM dual;

4167: -- 0,
4168: -- 0,
4169: -- 0,
4170: -- 0
4171: -- FROM dual;
4172:
4173: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW THEN
4174: FND_MSG_PUB.Add_Exc_Msg(
4175: p_pkg_name => G_PKG_NAME,

Line 4723: FROM dual;

4719: l_organization_id,
4720: l_inventory_item_id,
4721: l_rcv_transaction_id,
4722: l_receiving_cost
4723: FROM dual;
4724: END LOOP;
4725:
4726: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
4727: THEN