DBA Data[Home] [Help]

APPS.CTO_TRANSFER_PRICE_PK dependencies on OE_SYS_PARAMETERS

Line 420: select to_number( nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , org_id) , ship_from_org_id))

416: -- for the OU. In which case, we will populate ship_from_org_id.
417:
418: l_oeval_org_id number;
419: cursor get_oeval_org_id is
420: select to_number( nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , org_id) , ship_from_org_id))
421: from oe_order_lines_all
422: where line_id = p_line_id;
423:
424: BEGIN