DBA Data[Home] [Help]

APPS.OE_CNCL_VALIDATE_LINE dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 450: FROM financials_system_parameters fsp)

446: WHERE msi.inventory_item_id = p_inventory_item_id
447: AND org.organization_id= msi.organization_id
448: AND org.organization_id= p_ship_from_org_id
449: AND org.set_of_books_id= ( SELECT fsp.set_of_books_id
450: FROM financials_system_parameters fsp)
451: AND ROWNUM=1 ;
452:
453: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Receiving_Org',1);
454: RETURN TRUE;

Line 1088: FROM financials_system_parameters fsp);

1084: AND sysdate <= nvl( org.disable_date, sysdate)
1085: AND org.organization_id = nvl(p_line_rec.ship_from_org_id,
1086: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'))
1087: AND org.set_of_books_id= ( SELECT fsp.set_of_books_id
1088: FROM financials_system_parameters fsp);
1089:
1090: IF l_purchasing_enabled_flag = 'N' THEN
1091: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ENABLED');
1092: FND_MESSAGE.SET_TOKEN('ITEM', nvl(p_line_rec.ship_from_org_id,