APPS.PO_APPROVAL_REMINDER_SV dependencies on STANDARD

Line 299: AND type_lookup_code in ('STANDARD','PLANNED','BLANKET','CONTRACT')

295: WHERE NVL(authorization_status,'INCOMPLETE') IN
296: ('INCOMPLETE','REJECTED','REQUIRES REAPPROVAL')
297: -- AND WF_ITEM_TYPE = NULL
298: -- AND WF_ITEM_KEY = NULL
299: AND type_lookup_code in ('STANDARD','PLANNED','BLANKET','CONTRACT')
300: AND NVL(cancel_flag,'N') = 'N'
301: AND NVL(closed_code,'OPEN') <> 'FINALLY CLOSED';
302:
303:

Line 342: IF l_doc_subtype IN ('STANDARD','PLANNED') THEN

338: l_doc_subtype,
339: l_agent_id;
340:
341:
342: IF l_doc_subtype IN ('STANDARD','PLANNED') THEN
343: l_doc_type := 'PO';
344: ELSIF l_doc_subtype IN ('BLANKET','CONTRACT') THEN
345: l_doc_type := 'PA';
346: END IF;

Line 684: ('STANDARD','PLANNED','BLANKET','CONTRACT')

680: FROM PO_HEADERS poh
681: WHERE NVL(poh.authorization_status,'INCOMPLETE') = 'APPROVED'
682: AND NVL(poh.acceptance_required_flag,'N') in ('Y','D')
683: AND poh.type_lookup_code in
684: ('STANDARD','PLANNED','BLANKET','CONTRACT')
685: AND NVL(poh.cancel_flag,'N') = 'N'
686: AND NVL(poh.closed_code,'OPEN') <> 'FINALLY CLOSED'
687: AND not exists (
688: SELECT poa.ACCEPTANCE_ID

Line 1865: IF l_doc_subtype IN ('STANDARD','PLANNED') THEN

1861: IF l_doc_type_temp = 'PO_ACCEPTANCE' THEN
1862:
1863: -- temporary set l_doc_type to 'PO','PA' for acceptance WF
1864:
1865: IF l_doc_subtype IN ('STANDARD','PLANNED') THEN
1866: l_doc_type_temp := 'PO';
1867: ELSIF l_doc_subtype IN ('BLANKET','CONTRACT') THEN
1868: l_doc_type_temp := 'PA';
1869: END IF;

Line 2848: if ((p_DocumentTypeCode = 'STANDARD') or (p_DocumentTypeCode = 'PLANNED')) then

2844: and wias.activity_name = wi.root_activity;
2845:
2846: BEGIN
2847: l_doc_subtype := p_DocumentTypeCode;
2848: if ((p_DocumentTypeCode = 'STANDARD') or (p_DocumentTypeCode = 'PLANNED')) then
2849:
2850: x_progress := 'PO_APPROVAL_REMINDER_SV.cancel_notif-001';
2851:
2852: l_doc_type := 'PO';

Line 3237: -- We only consider Standard PO lines with approved, open,

3233: -- SQL What: Retrieve the Temp Labor lines that match either of the
3234: -- reminder criteria (Amount Billed Exceeds Budget, Contractor
3235: -- Assignment Nearing Completion), ignoring those that
3236: -- already had a notification sent.
3237: -- We only consider Standard PO lines with approved, open,
3238: -- non-cancelled shipments.
3239: -- SQL Why: To send notifications for these lines.
3240: --
3241: -- : Re-architected query to select SUM of

Line 3260: WHERE poh.type_lookup_code = 'STANDARD'

3256: , SUM(PLL.amount_billed) total_amount_billed
3257: FROM po_line_locations PLL
3258: , po_lines_all POL
3259: , po_headers_all poh
3260: WHERE poh.type_lookup_code = 'STANDARD'
3261: AND poh.po_header_id = POL.po_header_id
3262: AND POL.purchase_basis = 'TEMP LABOR'
3263: AND POL.po_line_id = PLL.po_line_id
3264: AND NVL(PLL.approved_flag, 'N') = 'Y'