APPS.OE_OE_FORM_LINE dependencies on OE_ORDER_SOURCES

Line 4402: from oe_order_sources

4398: IF (p_line_rec.source_document_type_id is not null) THEN
4399: BEGIN
4400: select name
4401: into x_line_val_rec.source_document_type
4402: from oe_order_sources
4403: where order_source_id=p_line_rec.source_document_type_id;
4404:
4405:
4406: EXCEPTION

Line 4698: from oe_order_sources

4694: p_line_rec.source_document_type_id IS NULL THEN
4695: -- Order Import
4696: Begin
4697: Select name into x_line_val_rec.order_source
4698: from oe_order_sources
4699: where order_source_id=p_line_rec.order_source_id;
4700: Exception
4701: when no_data_found then
4702: null;

Line 4715: from oe_order_sources

4711: p_line_rec.source_document_id IS NOT NULL THEN
4712: -- Copy Orders
4713: Begin
4714: Select name into x_line_val_rec.order_source
4715: from oe_order_sources
4716: where order_source_id=2;
4717:
4718: Select order_number into x_line_val_rec.order_source_ref
4719: from oe_order_headers

Line 4739: from oe_order_sources

4735: p_line_rec.order_source_id=10 THEN
4736: -- Internal Orders
4737: Begin
4738: Select name into x_line_val_rec.order_source
4739: from oe_order_sources
4740: where order_source_id=10;
4741:
4742: Exception
4743: when no_data_found then

Line 4755: from oe_order_sources

4751: AND p_line_rec.source_document_type_id<>2 THEN
4752:
4753: Begin
4754: Select name into x_line_val_rec.order_source
4755: from oe_order_sources
4756: where order_source_id=p_line_rec.source_document_type_id;
4757:
4758: Exception
4759: when no_data_found then