DBA Data[Home] [Help]

APPS.OE_ORDER_GRP dependencies on OE_ORDER_HEADERS

Line 1421: FROM OE_ORDER_HEADERS_ALL

1417: SELECT order_source_id, orig_sys_document_ref, change_sequence,
1418: source_document_type_id, source_document_id
1419: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1420: l_source_document_type_id, l_source_document_id
1421: FROM OE_ORDER_HEADERS_ALL
1422: WHERE header_id = p_header_rec.header_Id;
1423: EXCEPTION
1424: WHEN NO_DATA_FOUND THEN
1425: l_order_source_id := null;

Line 1479: FROM OE_ORDER_HEADERS_ALL

1475: SELECT order_source_id, orig_sys_document_ref, change_sequence,
1476: source_document_type_id, source_document_id
1477: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1478: l_source_document_type_id, l_source_document_id
1479: FROM OE_ORDER_HEADERS_ALL
1480: WHERE header_id = x_header_Adj_tbl(l_index).header_Id;
1481: EXCEPTION
1482: WHEN NO_DATA_FOUND THEN
1483: l_order_source_id := null;

Line 1541: FROM OE_ORDER_HEADERS_ALL

1537: SELECT order_source_id, orig_sys_document_ref, change_sequence,
1538: source_document_type_id, source_document_id
1539: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1540: l_source_document_type_id, l_source_document_id
1541: FROM OE_ORDER_HEADERS_ALL
1542: WHERE header_id = x_header_Scredit_tbl(l_index).header_id;
1543: EXCEPTION
1544: WHEN NO_DATA_FOUND THEN
1545: l_order_source_id := null;

Line 1603: FROM OE_ORDER_HEADERS_ALL

1599: SELECT order_source_id, orig_sys_document_ref, change_sequence,
1600: source_document_type_id, source_document_id
1601: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1602: l_source_document_type_id, l_source_document_id
1603: FROM OE_ORDER_HEADERS_ALL
1604: WHERE header_id = x_header_Payment_tbl(l_index).header_id;
1605: EXCEPTION
1606: WHEN NO_DATA_FOUND THEN
1607: l_order_source_id := null;

Line 2799: FROM OE_ORDER_HEADERS

2795: oe_debug_pub.add('AAC: Selecting Customer Based on old sold_to_org_id');
2796: END IF;
2797: SELECT SOLD_TO_ORG_ID
2798: INTO l_sold_to_org_id
2799: FROM OE_ORDER_HEADERS
2800: WHERE HEADER_ID = p_header_rec.header_id;
2801: x_header_rec.sold_to_org_id := l_sold_to_org_id;
2802: END IF;
2803: