DBA Data[Home] [Help]

APPS.OE_UPG_SO_NEW dependencies on OE_SYS_PARAMETERS

Line 1490: AND nvl(l.warehouse_id, nvl(v_master_org_for_single_org, oe_sys_parameters.value('MASTER_ORGANIZATION_ID', l.org_id))) = si.organization_id

1486: WHERE l.line_id= mol.line_id
1487: AND l.agreement_id = agr.agreement_id (+)
1488: AND l.commitment_id = ct.customer_trx_id (+)
1489: AND ct.agreement_id = comt.agreement_id (+)
1490: AND nvl(l.warehouse_id, nvl(v_master_org_for_single_org, oe_sys_parameters.value('MASTER_ORGANIZATION_ID', l.org_id))) = si.organization_id
1491: AND l.inventory_item_id = si.inventory_item_id;
1492:
1493: EXCEPTION
1494: WHEN NO_DATA_FOUND THEN