DBA Data[Home] [Help]

APPS.OE_DELAYED_REQUESTS_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 3665: FROM OE_ORDER_HEADERS_ALL

3661: SELECT order_source_id, orig_sys_document_ref, change_sequence,
3662: source_document_type_id, source_document_id
3663: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
3664: l_source_document_type_id, l_source_document_id
3665: FROM OE_ORDER_HEADERS_ALL
3666: WHERE header_id = l_request_rec.entity_id;
3667: EXCEPTION
3668: WHEN NO_DATA_FOUND THEN
3669: l_order_source_id := null;

Line 3746: FROM OE_ORDER_HEADERS_ALL

3742: SELECT order_source_id, orig_sys_document_ref, change_sequence,
3743: source_document_type_id, source_document_id
3744: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
3745: l_source_document_type_id, l_source_document_id
3746: FROM OE_ORDER_HEADERS_ALL
3747: WHERE header_id = l_header_id;
3748: EXCEPTION
3749: WHEN NO_DATA_FOUND THEN
3750: l_order_source_id := null;

Line 3842: FROM OE_ORDER_HEADERS_ALL

3838: SELECT order_source_id, orig_sys_document_ref, change_sequence,
3839: source_document_type_id, source_document_id
3840: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
3841: l_source_document_type_id, l_source_document_id
3842: FROM OE_ORDER_HEADERS_ALL
3843: WHERE header_id = l_header_id;
3844: EXCEPTION
3845: WHEN NO_DATA_FOUND THEN
3846: l_order_source_id := null;