SELECT
ooh.order_number "Order Number",
ooh.ordered_date "Ordered Date",
ooh.flow_status_code "Order Status",
ohd.name "Hold Name",
ohs.released_flag "Hold Release Flag",
ohr.release_reason_code "Hold Release Reason",
ohr.creation_date "Hold Release Date",
ooh.payment_type_code "Payment Type Code"
FROM apps.oe_order_headers_all ooh,
apps.oe_order_holds_all hld,
apps.oe_hold_sources_all ohs,
apps.oe_hold_definitions ohd,
apps.oe_hold_releases ohr
WHERE ooh.ordered_date BETWEEN :P_DATE_FROM AND :P_DATE_TO
AND ooh.order_category_code = 'ORDER'
AND ooh.header_id=hld.header_id(+)
AND hld.hold_source_id=ohs.hold_source_id(+)
AND ohs.hold_id=ohd.hold_id(+)
AND ohs.hold_release_id=ohr.hold_release_id(+)
ORDER BY ooh.order_number
Ur's
Amar Alam
ooh.order_number "Order Number",
ooh.ordered_date "Ordered Date",
ooh.flow_status_code "Order Status",
ohd.name "Hold Name",
ohs.released_flag "Hold Release Flag",
ohr.release_reason_code "Hold Release Reason",
ohr.creation_date "Hold Release Date",
ooh.payment_type_code "Payment Type Code"
FROM apps.oe_order_headers_all ooh,
apps.oe_order_holds_all hld,
apps.oe_hold_sources_all ohs,
apps.oe_hold_definitions ohd,
apps.oe_hold_releases ohr
WHERE ooh.ordered_date BETWEEN :P_DATE_FROM AND :P_DATE_TO
AND ooh.order_category_code = 'ORDER'
AND ooh.header_id=hld.header_id(+)
AND hld.hold_source_id=ohs.hold_source_id(+)
AND ohs.hold_id=ohd.hold_id(+)
AND ohs.hold_release_id=ohr.hold_release_id(+)
ORDER BY ooh.order_number
Ur's
Amar Alam
7 comments:
All are given information very excellent and easily understand all given information.
sap basis training in chennai
Thanks for sharing good info.
This is the exact information I am been searching for, Thanks for sharing the required infos with the clear update and required points. To appreciate this I like to share some useful information.
Oracle apps Training in Bangalore
"Loved this! Join our dell boomi full course
to gain expertise in building scalable integration workflows, managing APIs, and automating cloud-based processes efficiently."
⭐ Pega Classes
Interactive pega classes focus on practical learning with real-time examples.
Students learn UI design, rule configuration, and workflow creation.
Assignments improve development and analytical skills.
Live projects provide valuable industry experience.
Experienced trainers share real corporate implementation techniques.
Flexible batches suit students and working professionals.
These classes help you become a skilled Pega developer.
⭐ Pega Developer Course
A career-focused pega developer course teaches advanced application development techniques.
The course includes case types, data modeling, and integration concepts.
Hands-on exercises help build strong configuration knowledge.
Real-time projects provide exposure to enterprise-level applications.
Expert trainers guide learners through best development practices.
Flexible learning options support convenient study schedules.
This course prepares you for professional Pega developer roles.
SFDC Admin Course
The SFDC Admin Course is perfect for those aiming to specialize in Salesforce administration. It covers key topics like dashboards, workflows, and security settings. Practical assignments ensure better understanding of concepts. This course opens doors to many job opportunities.
"Great post! Our dell boomi training online
teaches you how to create seamless integrations, automate business processes, and manage APIs through hands-on training, preparing learners for high-demand roles in IT and cloud services."
Post a Comment