[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT DISTINCT
wdd.source_header_number
, wdd.source_header_id
, otl.name
, wdd.source_header_type_id
, party.party_name --c.customer_name
, party.party_id --c.customer_id
, party.party_number--c.customer_number
FROM wsh_delivery_details wdd
, hz_parties party --ra_customers c
, hz_cust_accounts cust_acct
, oe_transaction_types_tl otl
, wsh_delivery_assignments_v wda
WHERE wdd.customer_id = party.party_id
--c.customer_id
AND cust_acct.party_id = party.party_id
AND otl.language=userenv('LANG')
AND otl.transaction_type_id = wdd.source_header_type_id
AND wdd.organization_id = p_organization_id
AND wdd.source_code = 'OE'
AND wdd.date_scheduled is not null
--AND wdd.released_status in ('B','R','X')
AND wda.delivery_detail_id = wdd.delivery_detail_id
AND wda.parent_delivery_detail_id = p_parent_delivery_detail_id
ORDER BY 2,1;
SELECT DISTINCT
wdd.source_header_number
, wdd.source_header_id
, otl.name
, wdd.source_header_type_id
, party.party_name --c.customer_name
, party.party_id --c.customer_id
, party.party_number--c.customer_number
FROM wsh_delivery_details wdd
, hz_parties party --ra_customers c
, hz_cust_accounts cust_acct
, oe_transaction_types_tl otl
, wsh_delivery_assignments_v wda
WHERE wdd.customer_id = party.party_id
--c.customer_id
AND cust_acct.party_id = party.party_id
AND otl.language=userenv('LANG')
AND wdd.source_header_number like (p_order)
AND otl.transaction_type_id = wdd.source_header_type_id
AND wdd.organization_id = p_organization_id
AND wdd.source_code = 'OE'
AND wdd.date_scheduled is not null
--AND wdd.released_status in ('B','R','X')
AND wda.delivery_detail_id = wdd.delivery_detail_id
AND wda.parent_delivery_detail_id = p_parent_delivery_detail_id
ORDER BY 2,1;
SELECT DISTINCT
oel.line_id
, to_char(oel.line_number)||'.'||to_char(oel.shipment_number) ||
decode(oel.option_number,NULL,NULL,'.'||to_char(oel.option_number))||
decode(oel.component_number, null, null,decode(oel.option_number, null,'.',null)||
'.'||to_char(oel.component_number)) LINE_NUMBER
, oel.inventory_item_id
, oel.item_revision
, oel.PROJECT_ID
, oel.TASK_ID
, oel.END_ITEM_UNIT_NUMBER
, oel.SHIP_TOLERANCE_ABOVE
, oel.ship_tolerance_below
, oel.FLOW_STATUS_CODE
, oel.SHIPPING_INTERFACED_FLAG
, oel.REQUEST_DATE
, msik.serial_number_control_code
, msik.concatenated_segments
, 0
, ''
, 0
, 0
, 0
, 0
, ''
, ''
, ''
, ''
, 0
FROM oe_order_lines_all oel
, mtl_system_items_kfv msik
, wsh_delivery_details wdd
, wsh_delivery_assignments_v wda
WHERE oel.ship_from_org_id = p_organization_id
AND oel.header_id = p_source_header_id
AND oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')
AND wda.parent_delivery_detail_id = p_parent_delivery_detail_id
AND wdd.delivery_detail_id = wda.delivery_detail_id
AND oel.line_id = wdd.source_line_id
AND msik.inventory_item_id = oel.inventory_item_id
AND msik.organization_id = oel.ship_from_org_id
AND msik.mtl_transactions_enabled_flag <> 'N'
AND to_char(oel.line_number)||'.'||to_char(oel.shipment_number) ||
decode(oel.option_number,NULL,NULL,'.'||to_char(oel.option_number))||
decode(oel.component_number, null, null,decode(oel.option_number, null, '.',null)||
'.'||to_char(oel.component_number)) like (p_order_line)
ORDER BY 1,2;