DBA Data[Home] [Help]

APPS.INV_RESERVATION_VALIDATE_PVT dependencies on OE_DROP_SHIP_SOURCES

Line 361: from oe_drop_ship_sources

357: END IF;
358:
359: select count(1)
360: into l_dropship_count
361: from oe_drop_ship_sources
362: where po_header_id = p_supply_source_header_id
363: and line_location_id = p_supply_source_line_id;
364:
365: IF (l_debug = 1) THEN

Line 474: from oe_drop_ship_sources

470: END IF;
471:
472: select count(1)
473: into l_dropship_count
474: from oe_drop_ship_sources
475: where requisition_header_id = p_supply_source_header_id
476: and requisition_line_id = p_supply_source_line_id;
477:
478: IF (l_debug = 1) THEN

Line 1632: from oe_drop_ship_sources

1628:
1629: IF (p_demand_source_type_id = INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE and OE_DS_PVT.G_DS_SOISSUE_FLAG <> 'Y') THEN
1630: select count(1)
1631: into l_dropship_count
1632: from oe_drop_ship_sources
1633: where header_id = p_demand_source_header_id
1634: and line_id = p_demand_source_line_id;
1635:
1636: IF (l_debug = 1) THEN