APPS.PO_APPROVAL_REMINDER_SV dependencies on STANDARD

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

283: WHERE NVL(authorization_status,'INCOMPLETE') IN
284: ('INCOMPLETE','REJECTED','REQUIRES REAPPROVAL')
285: -- AND WF_ITEM_TYPE = NULL
286: -- AND WF_ITEM_KEY = NULL
287: AND type_lookup_code in ('STANDARD','PLANNED','BLANKET','CONTRACT')
288: AND NVL(cancel_flag,'N') = 'N'
289: AND NVL(closed_code,'OPEN') <> 'FINALLY CLOSED';
290:
291:

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

326: l_doc_subtype,
327: l_agent_id;
328:
329:
330: IF l_doc_subtype IN ('STANDARD','PLANNED') THEN
331: l_doc_type := 'PO';
332: ELSIF l_doc_subtype IN ('BLANKET','CONTRACT') THEN
333: l_doc_type := 'PA';
334: END IF;

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

668: FROM PO_HEADERS poh
669: WHERE NVL(poh.authorization_status,'INCOMPLETE') = 'APPROVED'
670: AND NVL(poh.acceptance_required_flag,'N') in ('Y','D')
671: AND poh.type_lookup_code in
672: ('STANDARD','PLANNED','BLANKET','CONTRACT')
673: AND NVL(poh.cancel_flag,'N') = 'N'
674: AND NVL(poh.closed_code,'OPEN') <> 'FINALLY CLOSED'
675: AND not exists (
676: SELECT poa.ACCEPTANCE_ID

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

1831: IF l_doc_type_temp = 'PO_ACCEPTANCE' THEN
1832:
1833: -- temporary set l_doc_type to 'PO','PA' for acceptance WF
1834:
1835: IF l_doc_subtype IN ('STANDARD','PLANNED') THEN
1836: l_doc_type_temp := 'PO';
1837: ELSIF l_doc_subtype IN ('BLANKET','CONTRACT') THEN
1838: l_doc_type_temp := 'PA';
1839: END IF;

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

2810: and wias.activity_name = wi.root_activity;
2811:
2812: BEGIN
2813: l_doc_subtype := p_DocumentTypeCode;
2814: if ((p_DocumentTypeCode = 'STANDARD') or (p_DocumentTypeCode = 'PLANNED')) then
2815:
2816: x_progress := 'PO_APPROVAL_REMINDER_SV.cancel_notif-001';
2817:
2818: l_doc_type := 'PO';

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

3199: -- SQL What: Retrieve the Temp Labor lines that match either of the
3200: -- reminder criteria (Amount Billed Exceeds Budget, Contractor
3201: -- Assignment Nearing Completion), ignoring those that
3202: -- already had a notification sent.
3203: -- We only consider Standard PO lines with approved, open,
3204: -- non-cancelled shipments.
3205: -- SQL Why: To send notifications for these lines.
3206: --
3207: -- : Re-architected query to select SUM of

Line 3226: WHERE poh.type_lookup_code = 'STANDARD'

3222: , SUM(PLL.amount_billed) total_amount_billed
3223: FROM po_line_locations PLL
3224: , po_lines_all POL
3225: , po_headers_all poh
3226: WHERE poh.type_lookup_code = 'STANDARD'
3227: AND poh.po_header_id = POL.po_header_id
3228: AND POL.purchase_basis = 'TEMP LABOR'
3229: AND POL.po_line_id = PLL.po_line_id
3230: AND NVL(PLL.approved_flag, 'N') = 'Y'