[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
ORGANIZATION_NAME
FROM
ORG_ORGANIZATION_DEFINITIONS
WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
SELECT
OI.ORG_INFORMATION1
FROM
HR_ORGANIZATION_INFORMATION OI
WHERE OI.ORGANIZATION_ID = P_ORGANIZATION_ID
AND OI.ORG_INFORMATION_CONTEXT = 'Employer Identification';
SELECT
MOI.ORG_INFORMATION1
FROM
MTL_PARAMETERS MP,
HR_ORGANIZATION_INFORMATION MOI
WHERE MP.ORGANIZATION_ID = P_ORGANIZATION_ID
AND MP.MASTER_ORGANIZATION_ID = MOI.ORGANIZATION_ID
AND MOI.ORG_INFORMATION_CONTEXT = 'Employer Identification';
SELECT
ID_FLEX_NUM
FROM
FND_ID_FLEX_STRUCTURES
WHERE ID_FLEX_CODE = FLEX_CODE;
LP_DEPARTURE_DATE := 'AND wnd.delivery_id IN (select distinct delivery_id from wsh_delivery_legs where pick_up_stop_id in (select stop_id from wsh_trip_stops where planned_departure_date <= :LP_DEPARTURE_DATE_HIGH))';
LP_DEPARTURE_DATE := 'AND wnd.delivery_id IN (select distinct delivery_id from wsh_delivery_legs where pick_up_stop_id in (select stop_id from wsh_trip_stops where planned_departure_date >= :P_DEPARTURE_DATE_LOW))';
LP_DEPARTURE_DATE := 'AND wnd.delivery_id in (select distinct delivery_id from wsh_delivery_legs where pick_up_stop_id in (select stop_id from wsh_trip_stops where planned_departure_date between :P_DEPARTURE_DATE_LOW
and :LP_DEPARTURE_DATE_HIGH))';
LP_TRIP_STOP_ID := 'AND wnd.delivery_id in (select distinct wdl.delivery_id from wsh_delivery_legs wdl where (wdl.pick_up_stop_id = :P_TRIP_STOP_ID
OR wdl.drop_off_stop_id = :P_TRIP_STOP_ID)) ';
SELECT
DECODE(FLAG
,'D'
,CUSTOMER_ITEM_DESC
,'F'
,CUSTOMER_ITEM_NUMBER
,CUSTOMER_ITEM_NUMBER || ' ' || CUSTOMER_ITEM_DESC) LABEL
FROM
MTL_CUSTOMER_ITEMS
WHERE CUSTOMER_ITEM_ID = ID;
SELECT
DESCRIPTION
FROM
MTL_SYSTEM_ITEMS_VL
WHERE INVENTORY_ITEM_ID = ID
AND ORGANIZATION_ID = ORG_ID;
SELECT
count(*)
FROM
WSH_DELIVERY_ASSIGNMENTS_V WDA,
WSH_DELIVERY_DETAILS WDD
WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
AND WDD.CONTAINER_FLAG = 'Y'
AND WDA.PARENT_DELIVERY_DETAIL_ID IS NULL
AND WDA.DELIVERY_ID is not null
AND WDA.DELIVERY_ID = DELIVERY_ID3;
SELECT
DISTINCT
WCS.SHIP_METHOD_MEANING
FROM
WSH_TRIPS T,
WSH_TRIP_STOPS ST,
WSH_DELIVERY_LEGS DG,
WSH_CARRIER_SERVICES WCS,
WSH_ORG_CARRIER_SERVICES WOCS
WHERE DG.DELIVERY_ID = DELIVERY_ID3
AND DG.PICK_UP_STOP_ID = ST.STOP_ID
AND ST.TRIP_ID = T.TRIP_ID
AND T.SHIP_METHOD_CODE <> NVL(SHIP_VIA
,'-1')
AND T.SHIP_METHOD_CODE = WCS.SHIP_METHOD_CODE
AND WCS.CARRIER_SERVICE_ID = WOCS.CARRIER_SERVICE_ID
AND WOCS.ORGANIZATION_ID = ORGANIZATION_ID1;
SELECT
WCS.SHIP_METHOD_MEANING
FROM
WSH_CARRIER_SERVICES WCS
WHERE WCS.SHIP_METHOD_CODE = SHIP_VIA;
SELECT
HP.PARTY_NAME,
NVL(HP.PERSON_PRE_NAME_ADJUNCT
,HP.PERSON_TITLE) TITLE
INTO SHIP_TO_CUST_NAME,L_PERSON_TITLE
FROM
HZ_PARTY_SITE_USES PSU,
HZ_PARTY_SITES PS,
HZ_PARTIES HP
WHERE PSU.PARTY_SITE_USE_ID = SHIP_TO_SITE_USE_ID
AND PSU.SITE_USE_TYPE = 'PURCHASING'
AND PS.PARTY_SITE_ID = PSU.PARTY_SITE_ID
AND HP.PARTY_ID = PS.PARTY_ID;
SELECT
HP.PARTY_NAME,
NVL(HP.PERSON_PRE_NAME_ADJUNCT
,HP.PERSON_TITLE) TITLE
INTO SHIP_TO_CUST_NAME,L_PERSON_TITLE
FROM
HZ_PARTY_SITES PS,
HZ_CUST_ACCT_SITES_ALL CA,
HZ_CUST_SITE_USES_ALL SU,
HZ_PARTIES HP
WHERE SU.SITE_USE_ID = SHIP_TO_SITE_USE_ID
AND SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID
AND CA.PARTY_SITE_ID = PS.PARTY_SITE_ID
AND HP.PARTY_ID = PS.PARTY_ID;
SELECT
MEANING || ' ' || SHIP_TO_CUST_NAME
INTO SHIP_TO_CUST_NAME
FROM
AR_LOOKUPS
WHERE LOOKUP_CODE = L_PERSON_TITLE_UP
AND LOOKUP_TYPE = L_LOOKUP_TYPE;
SELECT
PARTY.PARTY_NAME,
NVL(PARTY.PERSON_PRE_NAME_ADJUNCT
,PARTY.PERSON_TITLE) TITLE
INTO CONTACT_NAME,L_PERSON_TITLE
FROM
HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
HZ_PARTIES PARTY,
HZ_RELATIONSHIPS REL,
HZ_ORG_CONTACTS ORG_CONT,
HZ_PARTIES REL_PARTY
WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = SHIP_TO_CONTACT_ID
AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.DIRECTIONAL_FLAG = 'F'
AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
AND REL.SUBJECT_ID = PARTY.PARTY_ID
AND REL.PARTY_ID = REL_PARTY.PARTY_ID;
SELECT
MEANING || ' ' || CONTACT_NAME
INTO CONTACT_NAME
FROM
AR_LOOKUPS
WHERE LOOKUP_CODE = L_PERSON_TITLE_UP
AND LOOKUP_TYPE = L_LOOKUP_TYPE;
SELECT
CONCATENATED_SEGMENTS COMM_CLASS
FROM
MTL_CATEGORIES_KFV MC,
MTL_ITEM_CATEGORIES MIC,
MTL_CATEGORY_SETS_VL MCSTL
WHERE MIC.INVENTORY_ITEM_ID = C_INV_ITEM_ID
AND MIC.ORGANIZATION_ID = C_INV_ORG_ID
AND MIC.CATEGORY_SET_ID = MCSTL.CATEGORY_SET_ID
AND MC.CATEGORY_ID = MIC.CATEGORY_ID
AND MCSTL.CATEGORY_SET_NAME = 'WSH_COMMODITY_CODE'
ORDER BY
MC.CATEGORY_ID;
select unit_selling_price
from oe_order_lines_all
where line_id = p_source_line_id; --Bug 9166141 changed line_id to source_line_id
select unit_price
from oke_k_deliverables_b
where deliverable_id = p_source_line_id; --Bug 9166141 changed line_id to source_line_id
select unit_price
from wsh_delivery_details wdd
where wdd.source_line_id = p_source_line_id
and wdd.source_code = p_source_code
and rownum < 2;
select unit_selling_price
from oe_order_lines_all
where line_id = p_source_line_id; --Bug 9166141 changed line_id to source_line_id
select unit_price
from oke_k_deliverables_b
where deliverable_id = p_source_line_id; --Bug 9166141 changed line_id to source_line_id
select unit_price
from wsh_delivery_details wdd
where wdd.source_line_id = p_source_line_id
and wdd.source_code = p_source_code
and rownum < 2;