[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
SET_OF_BOOKS_ID
INTO P_SET_OF_BOOKS_ID
FROM
ORG_ORGANIZATION_DEFINITIONS
WHERE ORGANIZATION_ID = P_ORG_ID;
SELECT
CHART_OF_ACCOUNTS_ID
INTO L_COAID
FROM
GL_SETS_OF_BOOKS
WHERE SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID;
SELECT
USER_NAME
INTO P_REQUESTED_BY_NAME
FROM
FND_USER
WHERE USER_ID = P_REQUESTED_BY;
SELECT
ORG.ORGANIZATION_NAME
INTO P_ORG_NAME
FROM
ORG_ORGANIZATION_DEFINITIONS ORG
WHERE ORG.ORGANIZATION_ID = P_ORG_ID;
SELECT
PROJECT_NUMBER
INTO L_PROJECT_NUMBER
FROM
PJM_PROJECTS_V PJMP
WHERE PROJECT_ID = PJMP.PROJECT_ID;
SELECT
PROJECT_NUMBER
INTO L_PROJECT_NUMBER
FROM
PA_PROJECTS_EXPEND_V PPEV
WHERE PROJECT_ID = PPEV.PROJECT_ID
AND ROWNUM = 1;
SELECT
TASK_NUMBER
INTO L_TASK_NUMBER
FROM
PJM_TASKS_V PJMT
WHERE PROJECT_ID = PJMT.PROJECT_ID
AND TASK_ID = PJMT.TASK_ID;
SELECT
TASK_NUMBER
INTO L_TASK_NUMBER
FROM
PA_TASKS_EXPEND_V PTEV
WHERE PROJECT_ID = PTEV.PROJECT_ID
AND TASK_ID = PTEV.TASK_ID
AND ROWNUM = 1;
SELECT
MEANING
INTO P_MOVE_ORDER_TYPE_MEANING
FROM
MFG_LOOKUPS
WHERE LOOKUP_TYPE = 'INV_PICK_SLIP_MO_TYPES'
AND LOOKUP_CODE = P_MOVE_ORDER_TYPE;
SELECT
NAME
INTO P_PICK_SLIP_GROUP_RULE_NAME
FROM
WSH_PICK_GROUPING_RULES
WHERE PICK_GROUPING_RULE_ID = P_PICK_SLIP_GROUP_RULE_ID;
SELECT
MEANING
INTO P_PRINT_OPTION_MEANING
FROM
MFG_LOOKUPS
WHERE LOOKUP_TYPE = 'INV_PICK_SLIP_PRINT_OPTIONS'
AND LOOKUP_CODE = L_PRINT_OPTION;
SELECT
WE.ENTITY_TYPE
FROM
WIP_ENTITIES WE,
MTL_TXN_REQUEST_LINES MTRL
WHERE MTRL.LINE_ID = LINE_ID
AND WE.WIP_ENTITY_ID = MTRL.TXN_SOURCE_ID;
SELECT
WE.WIP_ENTITY_NAME JOB,
WL.LINE_CODE LINE,
WO.OPERATION_SEQ_NUM OPERATION,
BD.DEPARTMENT_CODE DEPARTMENT,
TO_CHAR(NULL) START_DATE
FROM
WIP_ENTITIES WE,
WIP_LINES WL,
BOM_DEPARTMENTS BD,
WIP_OPERATIONS WO,
WIP_DISCRETE_JOBS WDJ,
MTL_TXN_REQUEST_LINES MTRL
WHERE WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND WE.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
AND WDJ.LINE_ID = wl.line_id (+)
AND WDJ.ORGANIZATION_ID = wl.organization_id (+)
AND WO.DEPARTMENT_ID = bd.department_id (+)
AND MTRL.TXN_SOURCE_ID = wo.wip_entity_id (+)
AND MTRL.ORGANIZATION_ID = wo.organization_id (+)
AND MTRL.TXN_SOURCE_LINE_ID = wo.operation_seq_num (+)
AND WDJ.WIP_ENTITY_ID = MTRL.TXN_SOURCE_ID
AND WDJ.ORGANIZATION_ID = MTRL.ORGANIZATION_ID
AND MTRL.LINE_ID = LINE_ID_P;
SELECT
MSIK.CONCATENATED_SEGMENTS JOB,
WL.LINE_CODE LINE,
WO.OPERATION_SEQ_NUM OPERATION,
BD.DEPARTMENT_CODE DEPARTMENT,
TO_CHAR(WRS.FIRST_UNIT_START_DATE) START_DATE
FROM
MTL_SYSTEM_ITEMS_KFV MSIK,
WIP_ENTITIES WE,
WIP_LINES WL,
BOM_DEPARTMENTS BD,
WIP_OPERATIONS WO,
WIP_REPETITIVE_SCHEDULES WRS,
MTL_TXN_REQUEST_LINES MTRL
WHERE MSIK.INVENTORY_ITEM_ID = WE.PRIMARY_ITEM_ID
AND MSIK.ORGANIZATION_ID = WE.ORGANIZATION_ID
AND WE.WIP_ENTITY_ID = WRS.WIP_ENTITY_ID
AND WE.ORGANIZATION_ID = WRS.ORGANIZATION_ID
AND WL.LINE_ID = WRS.LINE_ID
AND WL.ORGANIZATION_ID = WRS.ORGANIZATION_ID
AND bd.department_id (+) = WO.DEPARTMENT_ID
AND wo.wip_entity_id (+) = MTRL.TXN_SOURCE_ID
AND wo.operation_seq_num (+) = MTRL.TXN_SOURCE_LINE_ID
AND wo.organization_id (+) = MTRL.ORGANIZATION_ID
AND wo.repetitive_schedule_id (+) = MTRL.REFERENCE_ID
AND WRS.WIP_ENTITY_ID = MTRL.TXN_SOURCE_ID
AND WRS.REPETITIVE_SCHEDULE_ID = MTRL.REFERENCE_ID
AND WRS.ORGANIZATION_ID = MTRL.ORGANIZATION_ID
AND MTRL.LINE_ID = LINE_ID_P;
SELECT
WE.WIP_ENTITY_NAME JOB,
WL.LINE_CODE LINE,
BOS2.OPERATION_SEQ_NUM OPERATION,
BD.DEPARTMENT_CODE DEPARTMENT,
TO_CHAR(NULL) START_DATE
FROM
WIP_ENTITIES WE,
WIP_LINES WL,
BOM_DEPARTMENTS BD,
BOM_OPERATION_SEQUENCES BOS2,
BOM_OPERATION_SEQUENCES BOS,
BOM_OPERATIONAL_ROUTINGS BOR,
WIP_FLOW_SCHEDULES WFS,
MTL_TXN_REQUEST_LINES MTRL
WHERE WE.WIP_ENTITY_ID = WFS.WIP_ENTITY_ID
AND WE.ORGANIZATION_ID = WFS.ORGANIZATION_ID
AND WL.LINE_ID = WFS.LINE_ID
AND WL.ORGANIZATION_ID = WFS.ORGANIZATION_ID
AND BD.DEPARTMENT_ID = BOS2.DEPARTMENT_ID
AND BOS2.OPERATION_SEQUENCE_ID = BOS.LINE_OP_SEQ_ID
AND BOS2.ROUTING_SEQUENCE_ID = BOS.ROUTING_SEQUENCE_ID
AND BOS.ROUTING_SEQUENCE_ID = BOR.ROUTING_SEQUENCE_ID
AND BOS.OPERATION_TYPE = 1
AND ( BOR.ALTERNATE_ROUTING_DESIGNATOR = WFS.ALTERNATE_ROUTING_DESIGNATOR
OR ( WFS.ALTERNATE_ROUTING_DESIGNATOR IS NULL
AND BOR.ALTERNATE_ROUTING_DESIGNATOR IS NULL ) )
AND BOR.ASSEMBLY_ITEM_ID = WFS.PRIMARY_ITEM_ID
AND BOR.ORGANIZATION_ID = WFS.ORGANIZATION_ID
AND WFS.WIP_ENTITY_ID = MTRL.TXN_SOURCE_ID
AND WFS.ORGANIZATION_ID = MTRL.ORGANIZATION_ID
AND MTRL.LINE_ID = LINE_ID_P;
SELECT
WDD.SOURCE_HEADER_NUMBER SO_NUMBER,
OEL.LINE_NUMBER SO_LINE_NUMBER,
WND.NAME DELIVERY_NAME
FROM
OE_ORDER_LINES_ALL OEL,
WSH_DELIVERY_DETAILS WDD,
WSH_DELIVERY_ASSIGNMENTS WDA,
WSH_NEW_DELIVERIES WND
WHERE WDD.MOVE_ORDER_LINE_ID = CF_SO_INFOFORMULA.LINE_ID
AND WDD.SOURCE_LINE_ID = OEL.LINE_ID
AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
AND WND.DELIVERY_ID (+) = WDA.DELIVERY_ID;
SELECT
PARTY.PARTY_NAME
INTO P_CUSTOMER_NAME
FROM
HZ_PARTIES PARTY,
HZ_CUST_ACCOUNTS CUST_ACCT
WHERE CUST_ACCT.CUST_ACCOUNT_ID = P_CUSTOMER_ID
AND PARTY.PARTY_ID = CUST_ACCT.PARTY_ID;
SELECT
MEANING
INTO L_MEANING
FROM
MFG_LOOKUPS
WHERE LOOKUP_TYPE = 'WMS_TASK_STATUS'
AND LOOKUP_CODE = TASK_STATUS;
SELECT
MEANING
INTO P_ALLOCATE_MOVE_ORDER_MEANING
FROM
FND_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO'
AND LOOKUP_CODE = P_ALLOCATE_MOVE_ORDER;
SELECT
MEANING
INTO P_PLAN_TASKS_MEANING
FROM
FND_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO'
AND LOOKUP_CODE = P_PLAN_TASKS;
SELECT
TRACKING_QUANTITY_IND
INTO L_TRACK_IND
FROM
MTL_SYSTEM_ITEMS_B
WHERE INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
AND ORGANIZATION_ID = P_ORG_ID;
SELECT
TRACKING_QUANTITY_IND
INTO L_TRACK_IND
FROM
MTL_SYSTEM_ITEMS_B
WHERE INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
AND ORGANIZATION_ID = P_ORG_ID;
SELECT
TRACKING_QUANTITY_IND
INTO L_TRACK_IND
FROM
MTL_SYSTEM_ITEMS_B
WHERE INVENTORY_ITEM_ID = PARENT_ITEM_ID
AND ORGANIZATION_ID = P_ORG_ID;
SELECT
TRACKING_QUANTITY_IND
INTO L_TRACK_IND
FROM
MTL_SYSTEM_ITEMS_B
WHERE INVENTORY_ITEM_ID = PARENT_ITEM_ID
AND ORGANIZATION_ID = P_ORG_ID;