[Home] [Help]
4: c_ENTITY_TYPE_LINE CONSTANT VARCHAR2(30) := PO_VALIDATIONS.C_ENTITY_TYPE_LINE;
5:
6: c_RATE CONSTANT VARCHAR2(30) := 'RATE';
7: c_FIXED_PRICE CONSTANT VARCHAR2(30) := 'FIXED PRICE';
8: c_STANDARD CONSTANT VARCHAR2(30) := 'STANDARD';
9: c_PLANNED CONSTANT VARCHAR2(30) := 'PLANNED';
10: c_TEMP_LABOR CONSTANT VARCHAR2(30) := 'TEMP LABOR';
11: c_BLANKET CONSTANT VARCHAR2(30) := 'BLANKET';
12: c_QUOTATION CONSTANT VARCHAR2(30) := 'QUOTATION';
321: FROM
322: ( SELECT
323: NVL(SUM(
324: (CASE
325: WHEN PLL.shipment_type <> c_STANDARD THEN 0
326: ELSE NVL(PLL.quantity_received, 0)
327: END)), 0) sum_qty_recv_actuals,
328: NVL(SUM(
329: (CASE
326: ELSE NVL(PLL.quantity_received, 0)
327: END)), 0) sum_qty_recv_actuals,
328: NVL(SUM(
329: (CASE
330: WHEN PLL.shipment_type <> c_STANDARD THEN 0
331: ELSE GREATEST(NVL(PLL.quantity_billed, 0),
332: NVL(PLL.quantity_financed, 0))
333: END)), 0) sum_qty_bill_actuals
334: FROM PO_LINE_LOCATIONS_ALL PLL
476: FROM
477: PO_DISTRIBUTIONS_ALL POD
478: WHERE
479: POD.po_line_id = p_line_id_tbl(i)
480: AND POD.distribution_type IN (c_STANDARD,c_PLANNED)
481: AND POD.encumbered_flag = 'Y'
482: ) DIST_TOTAL
483: WHERE
484: p_quantity_tbl(i) IS NOT NULL
677: FROM
678: ( SELECT
679: NVL(SUM(
680: (CASE
681: WHEN PLL.shipment_type <> c_STANDARD
682: THEN 0
683: WHEN PLL.payment_type = c_RATE
684: THEN
685: CASE
696: ELSE NVL(PLL.amount_received, 0)
697: END)), 0) sum_amt_recv_actuals,
698: NVL(SUM(
699: (CASE
700: WHEN PLL.shipment_type <> c_STANDARD
701: THEN 0
702: WHEN PLL.payment_type = c_RATE
703: THEN
704: CASE
762:
763:
764: -----------------------------------------------------------------------------
765: -- Validates that amount is greater than or equal to the sum of amounts
766: -- on timecards against a Rate Based Standard PO line.
767: -- This check is only performed if amount is being reduced below the
768: -- current transaction amount.
769: -----------------------------------------------------------------------------
770: PROCEDURE amount_ge_timecard(
826: WHERE
827: SES.key = l_data_key
828: AND LINE.po_line_id = SES.num1
829: AND HEADER.po_header_id = LINE.po_header_id
830: AND HEADER.type_lookup_code = c_STANDARD
831: AND LINE.order_type_lookup_code = c_RATE
832: AND SES.num2 < LINE.amount
833: ;
834:
833: ;
834:
835: FOR i IN 1 .. l_line_id_tbl.COUNT LOOP
836:
837: -- For Rate Based Standard PO lines where the amount has been decreased,
838: -- call the OTL API and identify the ones where the new amount is less than
839: -- the timecard sum.
840:
841: PO_HXC_INTERFACE_PVT.get_timecard_amount(
1016: , PO_ASL_STATUS_RULES_V PASR
1017: WHERE
1018: -- item is not null
1019: p_item_id_tbl(i) IS NOT NULL
1020: -- Document is standard PO
1021: AND p_type_lookup_code_tbl(i) = c_STANDARD
1022:
1023: --VMI is enabled
1024: AND paa.enable_vmi_flag = 'Y'
1017: WHERE
1018: -- item is not null
1019: p_item_id_tbl(i) IS NOT NULL
1020: -- Document is standard PO
1021: AND p_type_lookup_code_tbl(i) = c_STANDARD
1022:
1023: --VMI is enabled
1024: AND paa.enable_vmi_flag = 'Y'
1025: AND pasl.item_id = p_item_id_tbl(i)
1581: FROM PO_LINE_LOCATIONS_ALL PLL
1582: WHERE PLL.po_line_id = p_line_id_tbl(i)
1583: AND PLL.payment_type = c_MILESTONE
1584: AND PLL.value_basis = c_QUANTITY
1585: AND PLL.shipment_type = c_STANDARD
1586: )
1587: ) POLL_TOTAL, PO_LINES_ALL POL
1588: WHERE
1589: POL.po_line_id = p_line_id_tbl(i)
1670: FROM PO_LINE_LOCATIONS_ALL PLL
1671: WHERE PLL.po_line_id = p_line_id_tbl(i)
1672: AND PLL.payment_type = c_MILESTONE
1673: AND PLL.value_basis = c_QUANTITY
1674: AND PLL.shipment_type = c_STANDARD
1675: ) POLL_TOTAL, PO_LINES_ALL POL
1676: WHERE
1677: POL.po_line_id = p_line_id_tbl(i)
1678: AND p_price_tbl(i) IS NOT NULL