SELECTooha.order_number,wdd.DELIVERY_DETAIL_ID ,wda.delivery_detail_id,wnd.delivery_idfromoe_order_headers_all ooha,oe_order_lines_all oola,wsh_new_deliveries wnd,wsh_delivery_assignments wda,wsh_delivery_details wddwhere wdd.SOURCE_HEADER_ID=ooha.HEADER_IDAND wdd.source_line_id = ool.line_idand ooha.header_id=oola.HEADER_IDAND wdd.delivery_detail_id = wda.delivery_detail_idAND wnd.delivery_id = wda.delivery_idand ooha.ORDER_NUMBER=:ORDER_NUMB ...
Popular Posts
-
Query for Modifiers and Qualifiers in Oracle-R12 Pricing Price List : Price lists are essential for ordering products bec...
-
Reasons for a sales order to get Backordered Back Orders: The Oracle "term" backorder is a "status" on the order ... -
List of tables based on module and schema in oracle Apps R-12 Tables related to order management module ...
-
FNDLOAD: command not found Normally we use FNDLOADS to download and upload the ldts of program files for example concurrent program... -
Query to find Employee details,location and user Sharing query to find employee details based on its location.You can get u...
-
Oracle FNDLOAD Scripts - Download and update LDT's 1. Lookups -- ------------- Download Command : FNDLOAD apps/password O Y DOW...
-
PO details query in oracle apps R12 SELECT HOU.SHORT_CODE OU, PHA.CREATION_DATE PO_CREATION_DATE, PHA.A...
-
How to find Approver of Requisition in oracle Apps R12 SELECT distinct papf.full_name FROM po.po_action_history pah...
-
AP_INV_APRVL_HIST_ALL table will give you all the details related to approval of particular invoice. Query to get the latest transaction on ...
-
Importing journals Oracle Apps R12 To prepare for importing journals: 1. Define all account segment values used in your feeder systems...