[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
MEANING
FROM
OE_LOOKUPS
WHERE LOOKUP_CODE = T
AND LOOKUP_TYPE = 'YES_NO'
AND TRUNC(SYSDATE) BETWEEN NVL(START_DATE_ACTIVE
,TRUNC(SYSDATE))
AND NVL(END_DATE_ACTIVE
,TRUNC(SYSDATE));
SELECT
ID_FLEX_NUM
FROM
FND_ID_FLEX_STRUCTURES
WHERE ID_FLEX_CODE = FLEX_CODE;
( Select subinventory from wsh_report_printers wrp
where wrp.level_type_id = :P_LEVEL_TYPE_ID1
and wrp.enabled_flag = :P_ENABLED_FLAG
and wrp.CONCURRENT_PROGRAM_ID = (
select concurrent_program_id from
fnd_concurrent_programs_vl
where concurrent_program_name = :P_CONCURRENT_PROGRAM_NAME
and application_id = :P_APPLICATION_ID
and rownum = 1 )
and wrp.organization_id = wdd.organization_id )
and wdd.organization_id not in
( Select wrp.level_value_id from wsh_report_printers wrp
where wrp.level_type_id = :P_LEVEL_TYPE_ID2
and wrp.enabled_flag = :P_ENABLED_FLAG
and wrp.CONCURRENT_PROGRAM_ID = (
select concurrent_program_id from
fnd_concurrent_programs_vl
where concurrent_program_name = :P_CONCURRENT_PROGRAM_NAME
and application_id = :P_APPLICATION_ID
and rownum = 1 ) ) ';
( Select wrp.subinventory from wsh_report_printers wrp
where wrp.level_type_id = :P_LEVEL_TYPE_ID1
and wrp.enabled_flag = :P_ENABLED_FLAG
and wrp.CONCURRENT_PROGRAM_ID = (
select concurrent_program_id from
fnd_concurrent_programs_vl
where concurrent_program_name = :P_CONCURRENT_PROGRAM_NAME
and application_id = :P_APPLICATION_ID
and rownum = 1 )
and wrp.organization_id = wdd.organization_id
and wrp.printer_name = :p_printer_name )
or (wdd.organization_id in
( Select wrp.level_value_id from wsh_report_printers wrp
where wrp.level_type_id = :P_LEVEL_TYPE_ID2
and wrp.enabled_flag = :P_ENABLED_FLAG
and wrp.printer_name = :p_printer_name
and wrp.CONCURRENT_PROGRAM_ID = (
select concurrent_program_id from
fnd_concurrent_programs_vl
where concurrent_program_name = :P_CONCURRENT_PROGRAM_NAME
and application_id = :P_APPLICATION_ID
and rownum = 1 ) )
and wpsv.subinventory_code not in
( select wrp.subinventory
from wsh_Report_printers wrp
where wrp.level_type_id = :P_LEVEL_TYPE_ID1
and wrp.enabled_flag = :P_ENABLED_FLAG
and wrp.CONCURRENT_PROGRAM_ID =(
select concurrent_program_id from
fnd_concurrent_programs_vl
where concurrent_program_name = :P_CONCURRENT_PROGRAM_NAME
and application_id = :P_APPLICATION_ID
and rownum = 1 )
and wrp.organization_id = wdd.organization_id )))' ; --bug 9278128
SELECT
SUM(ABS(TRANSACTION_QUANTITY))
INTO LOT_QTY
FROM
MTL_TRANSACTION_LOT_NUMBERS
WHERE TRANSACTION_ID = LOT_TXN_ID
AND LOT_NUMBER = LOT_NUMBER1
GROUP BY
TRANSACTION_ID,
LOT_NUMBER;
SELECT
SUM(ABS(TRANSACTION_QUANTITY))
INTO LOT_QTY
FROM
MTL_TRANSACTION_LOTS_TEMP
WHERE TRANSACTION_TEMP_ID = LOT_TXN_ID
AND LOT_NUMBER = LOT_NUMBER1
GROUP BY
TRANSACTION_TEMP_ID,
LOT_NUMBER;
SELECT
SUM(ABS(TRANSACTION_QUANTITY))
INTO LOT_QTY
FROM
MTL_MATERIAL_TRANSACTIONS_TEMP
WHERE TRANSACTION_TEMP_ID = LOT_TXN_ID
AND ( REVISION IS NOT NULL
OR LOCATOR_ID IS NOT NULL )
GROUP BY
TRANSACTION_TEMP_ID;
SELECT
NVL(PICKED_QUANTITY,REQUESTED_QUANTITY)
INTO LOT_QTY
FROM
WSH_DELIVERY_DETAILS
WHERE DELIVERY_DETAIL_ID = DELIVERY_DETAIL_ID3;
SELECT
SUM(REQUESTED_QUANTITY)
INTO REQ_QTY
FROM
WSH_DELIVERY_DETAILS
WHERE SOURCE_HEADER_ID = SOURCE_HEADER_ID1
AND SOURCE_LINE_ID = SOURCE_LINE_ID1
AND MOVE_ORDER_LINE_ID = MOVE_ORDER_LINE_ID1
AND NVL(LINE_DIRECTION
,'O') IN ( 'O' , 'IO' )
AND CONTAINER_FLAG in ( 'Y' , 'N' );
SELECT
REVISION
INTO REVISION
FROM
MTL_MATERIAL_TRANSACTIONS_TEMP
WHERE TRANSACTION_TEMP_ID = TRANSACTION_ID1;
SELECT
REVISION
INTO REVISION
FROM
MTL_MATERIAL_TRANSACTIONS
WHERE TRANSACTION_ID = TRANSACTION_ID1;
SELECT
WT.TRIP_ID,
WT.NAME
FROM
WSH_TRIPS WT,
WSH_TRIP_STOPS WTS,
WSH_DELIVERY_LEGS WDL
WHERE WDL.DELIVERY_ID = DELIVERY_ID1
AND WTS.STOP_LOCATION_ID = INITIAL_PICKUP_LOCATION_ID
AND WTS.STOP_ID = WDL.PICK_UP_STOP_ID
AND WTS.TRIP_ID = WT.TRIP_ID;
SELECT
SUBSTRB(PARTY.PARTY_NAME
,1
,50) CUSTOMER_NAME
FROM
HZ_PARTIES PARTY,
HZ_CUST_ACCOUNTS CUST_ACCT,
OE_ORDER_HEADERS_ALL OH
WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND OH.HEADER_ID = O_ID
AND CUST_ACCT.CUST_ACCOUNT_ID = OH.SOLD_TO_ORG_ID;
SELECT
SUBSTRB(PARTY.PARTY_NAME
,1
,50) CUSTOMER_NAME
FROM
HZ_PARTIES PARTY,
HZ_CUST_ACCOUNTS CUST_ACCT,
OE_ORDER_HEADERS_ALL OH
WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND OH.HEADER_ID = O_ID
AND CUST_ACCT.CUST_ACCOUNT_ID = OH.SOLD_TO_ORG_ID;
SELECT
LOC.ADDRESS1,
LOC.ADDRESS2,
LOC.ADDRESS3,
LOC.ADDRESS4,
LOC.CITY || DECODE(LOC.CITY
,NULL
,''
,', ') || NVL(LOC.STATE
,LOC.PROVINCE) || DECODE(LOC.POSTAL_CODE
,NULL
,''
,' ' || LOC.POSTAL_CODE) || DECODE(NVL(LOC.STATE
,NVL(LOC.PROVINCE
,LOC.POSTAL_CODE))
,NULL
,''
,', ') || LOC.COUNTRY
FROM
WSH_TRIP_STOPS WTS,
WSH_DELIVERY_LEGS WDL,
WSH_LOCATIONS LOC
WHERE WDL.DELIVERY_ID = P_DELIVERY_ID
AND WDL.PICK_UP_STOP_ID = WTS.STOP_ID
AND WTS.STOP_LOCATION_ID = LOC.WSH_LOCATION_ID;
SELECT
LOC.ADDRESS1,
LOC.ADDRESS2,
LOC.ADDRESS3,
LOC.ADDRESS4,
LOC.CITY || DECODE(LOC.CITY
,NULL
,''
,', ') || NVL(LOC.STATE
,LOC.PROVINCE) || DECODE(LOC.POSTAL_CODE
,NULL
,''
,' ' || LOC.POSTAL_CODE) || DECODE(NVL(LOC.STATE
,NVL(LOC.PROVINCE
,LOC.POSTAL_CODE))
,NULL
,''
,', ') || LOC.COUNTRY
FROM
WSH_TRIP_STOPS WTS,
WSH_DELIVERY_LEGS WDL,
WSH_DELIVERY_ASSIGNMENTS_V WDA,
WSH_DELIVERY_DETAILS WDD,
MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,
WSH_LOCATIONS LOC
WHERE MMTT.PICK_SLIP_NUMBER = X_PS_NUMBER
AND MMTT.MOVE_ORDER_LINE_ID = WDD.MOVE_ORDER_LINE_ID
AND MMTT.PICK_SLIP_NUMBER IS NOT NULL
AND ABS(NVL(MMTT.TRANSACTION_QUANTITY
,0)) > 0
AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
AND WDA.DELIVERY_ID = WDL.DELIVERY_ID
AND WDL.PICK_UP_STOP_ID = WTS.STOP_ID
AND WTS.STOP_LOCATION_ID = LOC.WSH_LOCATION_ID
AND NVL(WDD.LINE_DIRECTION
,'O') IN ( 'O' , 'IO' )
AND WDD.CONTAINER_FLAG IN ( 'N' , 'Y' )
UNION ALL
SELECT
LOC.ADDRESS1,
LOC.ADDRESS2,
LOC.ADDRESS3,
LOC.ADDRESS4,
LOC.CITY || DECODE(LOC.CITY
,NULL
,''
,', ') || NVL(LOC.STATE
,LOC.PROVINCE) || DECODE(LOC.POSTAL_CODE
,NULL
,''
,' ' || LOC.POSTAL_CODE) || DECODE(NVL(LOC.STATE
,NVL(LOC.PROVINCE
,LOC.POSTAL_CODE))
,NULL
,''
,', ') || LOC.COUNTRY
FROM
WSH_TRIP_STOPS WTS,
WSH_DELIVERY_LEGS WDL,
WSH_DELIVERY_ASSIGNMENTS_V WDA,
WSH_DELIVERY_DETAILS WDD,
MTL_MATERIAL_TRANSACTIONS MMT,
WSH_LOCATIONS LOC
WHERE MMT.PICK_SLIP_NUMBER = X_PS_NUMBER
AND MMT.MOVE_ORDER_LINE_ID = WDD.MOVE_ORDER_LINE_ID
AND MMT.PICK_SLIP_NUMBER IS NOT NULL
AND NVL(MMT.TRANSACTION_QUANTITY
,0) < 0
AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
AND WDA.DELIVERY_ID = WDL.DELIVERY_ID
AND WDL.PICK_UP_STOP_ID = WTS.STOP_ID
AND WTS.STOP_LOCATION_ID = LOC.WSH_LOCATION_ID
AND NVL(WDD.LINE_DIRECTION
,'O') IN ( 'O' , 'IO' )
AND WDD.CONTAINER_FLAG IN ( 'N' , 'Y' )
UNION ALL
SELECT
LOC.ADDRESS1,
LOC.ADDRESS2,
LOC.ADDRESS3,
LOC.ADDRESS4,
LOC.CITY || DECODE(LOC.CITY
,NULL
,''
,', ') || NVL(LOC.STATE
,LOC.PROVINCE) || DECODE(LOC.POSTAL_CODE
,NULL
,''
,' ' || LOC.POSTAL_CODE) || DECODE(NVL(LOC.STATE
,NVL(LOC.PROVINCE
,LOC.POSTAL_CODE))
,NULL
,''
,', ') || LOC.COUNTRY
FROM
WSH_TRIP_STOPS WTS,
WSH_DELIVERY_LEGS WDL,
WSH_DELIVERY_ASSIGNMENTS_V WDA,
WSH_DELIVERY_DETAILS WDD,
MTL_TXN_REQUEST_LINES MTRL,
WSH_LOCATIONS LOC
WHERE MTRL.PICK_SLIP_NUMBER = X_PS_NUMBER
AND MTRL.LINE_ID = WDD.MOVE_ORDER_LINE_ID
AND MTRL.PICK_SLIP_NUMBER IS NOT NULL
AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
AND WDA.DELIVERY_ID = WDL.DELIVERY_ID
AND WDL.PICK_UP_STOP_ID = WTS.STOP_ID
AND WTS.STOP_LOCATION_ID = LOC.WSH_LOCATION_ID
AND NVL(WDD.LINE_DIRECTION
,'O') IN ( 'O' , 'IO' )
AND WDD.CONTAINER_FLAG IN ( 'N' , 'Y' );
SELECT
ORIG_SYS_DOCUMENT_REF
FROM
OE_ORDER_HEADERS_ALL
WHERE HEADER_ID = X_ORDER_HEADER
AND SOURCE_DOCUMENT_TYPE_ID = 10;
SELECT
LOC.ADDRESS1,
LOC.ADDRESS2,
LOC.ADDRESS3,
LOC.ADDRESS4,
LOC.CITY || DECODE(LOC.CITY
,NULL
,''
,', ') || NVL(LOC.STATE
,LOC.PROVINCE) || DECODE(LOC.POSTAL_CODE
,NULL
,''
,' ' || LOC.POSTAL_CODE) || DECODE(NVL(LOC.STATE
,NVL(LOC.PROVINCE
,LOC.POSTAL_CODE))
,NULL
,''
,', ') || LOC.COUNTRY
FROM
WSH_LOCATIONS LOC
WHERE LOC.WSH_LOCATION_ID = (
SELECT
WDD.SHIP_TO_LOCATION_ID
FROM
WSH_DELIVERY_DETAILS WDD,
WSH_PICK_SLIP_V WPSV
WHERE WPSV.PICK_SLIP_NUMBER = X_PS_NUM
AND WPSV.MOVE_ORDER_LINE_ID = WDD.MOVE_ORDER_LINE_ID
AND ROWNUM = 1 );
SELECT
MEANING
FROM
FND_LOOKUP_VALUES_VL
WHERE LOOKUP_CODE = X_CARRIER
AND LOOKUP_TYPE = 'SHIP_METHOD'
AND VIEW_APPLICATION_ID = 3;
SELECT
NAME
FROM
HR_ORGANIZATION_UNITS
WHERE ORGANIZATION_ID = ORGANIZATION_ID1;
SELECT
ORGANIZATION_CODE
FROM
MTL_PARAMETERS
WHERE ORGANIZATION_ID = ORGANIZATION_ID1;
SELECT
FV.FREIGHT_TERMS
FROM
OE_FRGHT_TERMS_ACTIVE_V FV
WHERE FV.FREIGHT_TERMS_CODE = FREIGHT_TERMS;