APPS.OE_OE_FORM_LINE dependencies on OE_ORDER_SOURCES

Line 4680: from oe_order_sources

4676: IF (p_line_rec.source_document_type_id is not null) THEN
4677: BEGIN
4678: select name
4679: into x_line_val_rec.source_document_type
4680: from oe_order_sources
4681: where order_source_id=p_line_rec.source_document_type_id;
4682:
4683:
4684: EXCEPTION

Line 4976: from oe_order_sources

4972: p_line_rec.source_document_type_id IS NULL THEN
4973: -- Order Import
4974: Begin
4975: Select name into x_line_val_rec.order_source
4976: from oe_order_sources
4977: where order_source_id=p_line_rec.order_source_id;
4978: Exception
4979: when no_data_found then
4980: null;

Line 4993: from oe_order_sources

4989: p_line_rec.source_document_id IS NOT NULL THEN
4990: -- Copy Orders
4991: Begin
4992: Select name into x_line_val_rec.order_source
4993: from oe_order_sources
4994: where order_source_id=2;
4995:
4996: Select order_number into x_line_val_rec.order_source_ref
4997: from oe_order_headers

Line 5017: from oe_order_sources

5013: p_line_rec.order_source_id=10 THEN
5014: -- Internal Orders
5015: Begin
5016: Select name into x_line_val_rec.order_source
5017: from oe_order_sources
5018: where order_source_id=10;
5019:
5020: Exception
5021: when no_data_found then

Line 5033: from oe_order_sources

5029: AND p_line_rec.source_document_type_id<>2 THEN
5030:
5031: Begin
5032: Select name into x_line_val_rec.order_source
5033: from oe_order_sources
5034: where order_source_id=p_line_rec.source_document_type_id;
5035:
5036: Exception
5037: when no_data_found then