[Home] [Help]
1800: SELECT PH.po_header_id,
1801: p_purge_name,
1802: 'Y'
1803: FROM po_headers PH
1804: WHERE PH.type_lookup_code IN ('STANDARD', 'PLANNED',
1805: 'BLANKET', 'CONTRACT')
1806: AND PH.last_update_date <= p_last_activity_date
1807: AND (PH.closed_code = 'FINALLY CLOSED'
1808: OR PH.cancel_flag = 'Y')
1861: SELECT PH.po_header_id,
1862: p_purge_name,
1863: 'Y'
1864: FROM po_headers PH
1865: WHERE PH.type_lookup_code IN ('STANDARD', 'PLANNED',
1866: 'BLANKET', 'CONTRACT')
1867: AND PH.last_update_date <= p_last_activity_date
1868: AND (PH.closed_code = 'FINALLY CLOSED'
1869: OR PH.cancel_flag = 'Y')
3366: AND NOT EXISTS (
3367: SELECT NULL
3368: FROM po_headers PH
3369: WHERE PH.po_header_id = PPL.po_header_id
3370: AND PH.type_lookup_code IN ('STANDARD', 'BLANKET',
3371: 'PLANNED', 'CONTRACT')
3372: AND (PH.cancel_flag = 'Y'
3373: OR PH.closed_code = 'FINALLY CLOSED')
3374: AND PH.last_update_date <= p_last_activity_date
3435: AND NOT EXISTS (
3436: SELECT NULL
3437: FROM po_headers PH
3438: WHERE PH.po_header_id = PPL.po_header_id
3439: AND PH.type_lookup_code IN ('STANDARD', 'BLANKET',
3440: 'PLANNED', 'CONTRACT')
3441: AND (PH.cancel_flag = 'Y'
3442: OR PH.closed_code = 'FINALLY CLOSED')
3443: AND PH.last_update_date <= p_last_activity_date
4030: IF (l_range_inserted = 'N') THEN -- current batch is not inserted
4031: l_progress := '030';
4032:
4033: -- SQL What: Insert data into history tables for records in the
4034: -- purge list that are Standard POs, Planned POs, and
4035: -- Local Blanket PA
4036: -- SQL Why: Need to record data in history table before actual
4037: -- purge happens
4038:
4076: WHERE PPL.po_header_id BETWEEN l_range_low AND l_range_high
4077: AND PPL.double_check_flag = 'Y'
4078: AND PPL.po_header_id = PH.po_header_id
4079: AND NVL(PH.global_agreement_flag, 'N') = 'N'
4080: AND PH.type_lookup_code IN ('STANDARD', 'PLANNED', 'BLANKET')
4081: AND PH.po_header_id = PLL.po_header_id(+)
4082: AND PLL.shipment_type (+) <> 'PRICE BREAK'
4083: AND PH.agent_id = PAPF.person_id
4084: AND TRUNC(SYSDATE) BETWEEN PAPF.effective_start_date
5173: PO_CONSTANTS_SV.PO_ENTITY_CODE,
5174: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
5175: l_po_header_id_tbl(i)
5176: from dual
5177: where l_type_lookup_code_tbl(i) IN ('STANDARD', 'PLANNED');
5178:
5179: FORALL i in 1..l_po_release_id_tbl.count
5180: insert into zx_purge_transactions_gt(
5181: application_id,