APPS.PO_LOCKS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 92

SELECT NULL
FROM
   PO_REQUISITION_HEADERS_ALL PRH
,  PO_SESSION_GT IDS
WHERE PRH.requisition_header_id = IDS.num1
AND IDS.key = p_doc_id_key
FOR UPDATE OF PRH.requisition_header_id
NOWAIT
;

Line: 103

SELECT NULL
FROM
   PO_RELEASES_ALL POR
,  PO_SESSION_GT IDS
WHERE POR.po_release_id = IDS.num1
AND IDS.key = p_doc_id_key
FOR UPDATE OF POR.po_release_id
NOWAIT
;

Line: 114

SELECT NULL
FROM
   PO_HEADERS_ALL POH
,  PO_SESSION_GT IDS
WHERE POH.po_header_id = IDS.num1
AND IDS.key = p_doc_id_key
FOR UPDATE OF POH.po_header_id
NOWAIT
;

Line: 128

SELECT NULL
FROM
   PO_REQUISITION_HEADERS_ALL PRH
,  PO_SESSION_GT IDS
WHERE PRH.requisition_header_id = IDS.num1
AND IDS.key = p_doc_id_key
FOR UPDATE
;

Line: 138

SELECT NULL
FROM
   PO_RELEASES_ALL POR
,  PO_SESSION_GT IDS
WHERE POR.po_release_id = IDS.num1
AND IDS.key = p_doc_id_key
FOR UPDATE
;

Line: 148

SELECT NULL
FROM
   PO_HEADERS_ALL POH
,  PO_SESSION_GT IDS
WHERE POH.po_header_id = IDS.num1
AND IDS.key = p_doc_id_key
FOR UPDATE
;

Line: 183

SELECT PO_SESSION_GT_S.nextval
INTO l_doc_id_key
FROM DUAL
;

Line: 191

INSERT INTO PO_SESSION_GT ( key, num1 )
VALUES ( l_doc_id_key, l_doc_id_tbl(i) )
;

Line: 365

SELECT NULL
FROM
   PO_REQ_DISTRIBUTIONS_ALL PRD
,  PO_SESSION_GT DIST_IDS
WHERE PRD.distribution_id = DIST_IDS.num1
AND DIST_IDS.key = p_dist_id_key
FOR UPDATE OF PRD.distribution_id
NOWAIT
;

Line: 376

SELECT NULL
FROM
   PO_DISTRIBUTIONS_ALL POD
,  PO_SESSION_GT DIST_IDS
WHERE POD.po_distribution_id = DIST_IDS.num1
AND DIST_IDS.key = p_dist_id_key
FOR UPDATE OF POD.po_distribution_id
NOWAIT
;

Line: 411

SELECT PO_SESSION_GT_S.nextval
INTO l_dist_id_key
FROM DUAL
;

Line: 419

INSERT INTO PO_SESSION_GT ( key, num1 )
VALUES ( l_dist_id_key, l_dist_id_tbl(i) )
;

Line: 504

SELECT *
FROM MRP_SOURCING_RULES
FOR UPDATE OF sourcing_rule_id
NOWAIT
;