DBA Data[Home] [Help]

APPS.OE_BATCH_PRICING dependencies on OE_SYS_PARAMETERS

Line 142: and ic.organization_id = oe_sys_parameters.Value('MASTER_ORGANIZATION_ID',l.org_id)

138: and l.inventory_item_id = nvl(p_inventory_item_id, l.inventory_item_id)
139: and l.creation_date between nvl(l_line_creation_date_low, l.creation_date) and nvl(l_line_creation_date_high, l.creation_date)
140: and nvl(l.pricing_date, sysdate) between nvl(l_pricing_date_low, nvl(l.pricing_date, sysdate)) and nvl(l_pricing_date_high, nvl(l.pricing_date, sysdate))
141: and nvl(l.schedule_ship_date, sysdate) between nvl(l_schedule_ship_date_low, nvl(l.schedule_ship_date, sysdate)) and nvl(l_schedule_ship_date_high, nvl(l.schedule_ship_date, sysdate))
142: and ic.organization_id = oe_sys_parameters.Value('MASTER_ORGANIZATION_ID',l.org_id)
143: and ic.inventory_item_id = l.inventory_item_id
144: and ic.category_set_id = cs.category_set_id
145: and ic.category_id = nvl(p_item_category_id, ic.category_id)
146: and cs.functional_area_id = 7