eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_VAL_LINES dependencies on STANDARD

Line 8: c_STANDARD CONSTANT VARCHAR2(30) := 'STANDARD';

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';

Line 439: WHEN PLL.shipment_type <> c_STANDARD THEN 0

435: FROM
436: ( SELECT
437: NVL(SUM(
438: (CASE
439: WHEN PLL.shipment_type <> c_STANDARD THEN 0
440: ELSE NVL(PLL.quantity_received, 0)
441: END)), 0) sum_qty_recv_actuals,
442: NVL(SUM(
443: (CASE

Line 444: WHEN PLL.shipment_type <> c_STANDARD THEN 0

440: ELSE NVL(PLL.quantity_received, 0)
441: END)), 0) sum_qty_recv_actuals,
442: NVL(SUM(
443: (CASE
444: WHEN PLL.shipment_type <> c_STANDARD THEN 0
445: ELSE GREATEST(NVL(PLL.quantity_billed, 0),
446: NVL(PLL.quantity_financed, 0))
447: END)), 0) sum_qty_bill_actuals
448: FROM PO_LINE_LOCATIONS_ALL PLL

Line 734: AND POD.distribution_type IN (c_STANDARD,c_PLANNED)

730: FROM
731: PO_DISTRIBUTIONS_ALL POD
732: WHERE
733: POD.po_line_id = p_line_id_tbl(i)
734: AND POD.distribution_type IN (c_STANDARD,c_PLANNED)
735: AND POD.encumbered_flag = 'Y'
736: ) DIST_TOTAL
737: WHERE
738: p_quantity_tbl(i) IS NOT NULL

Line 941: WHEN PLL.shipment_type <> c_STANDARD

937: FROM
938: ( SELECT
939: NVL(SUM(
940: (CASE
941: WHEN PLL.shipment_type <> c_STANDARD
942: THEN 0
943: WHEN PLL.payment_type = c_RATE
944: THEN
945: CASE

Line 960: WHEN PLL.shipment_type <> c_STANDARD

956: ELSE NVL(PLL.amount_received, 0)
957: END)), 0) sum_amt_recv_actuals,
958: NVL(SUM(
959: (CASE
960: WHEN PLL.shipment_type <> c_STANDARD
961: THEN 0
962: WHEN PLL.payment_type = c_RATE
963: THEN
964: CASE

Line 1026: -- on timecards against a Rate Based Standard PO line.

1022:
1023:
1024: -----------------------------------------------------------------------------
1025: -- Validates that amount is greater than or equal to the sum of amounts
1026: -- on timecards against a Rate Based Standard PO line.
1027: -- This check is only performed if amount is being reduced below the
1028: -- current transaction amount.
1029: -----------------------------------------------------------------------------
1030: PROCEDURE amount_ge_timecard(

Line 1090: AND HEADER.type_lookup_code = c_STANDARD

1086: WHERE
1087: SES.key = l_data_key
1088: AND LINE.po_line_id = SES.num1
1089: AND HEADER.po_header_id = LINE.po_header_id
1090: AND HEADER.type_lookup_code = c_STANDARD
1091: AND LINE.order_type_lookup_code = c_RATE
1092: AND SES.num2 < LINE.amount
1093: ;
1094:

Line 1097: -- For Rate Based Standard PO lines where the amount has been decreased,

1093: ;
1094:
1095: FOR i IN 1 .. l_line_id_tbl.COUNT LOOP
1096:
1097: -- For Rate Based Standard PO lines where the amount has been decreased,
1098: -- call the OTL API and identify the ones where the new amount is less than
1099: -- the timecard sum.
1100:
1101: PO_HXC_INTERFACE_PVT.get_timecard_amount(

Line 1284: -- Document is standard PO

1280: , PO_ASL_STATUS_RULES_V PASR
1281: WHERE
1282: -- item is not null
1283: p_item_id_tbl(i) IS NOT NULL
1284: -- Document is standard PO
1285: AND p_type_lookup_code_tbl(i) = c_STANDARD
1286:
1287: --VMI is enabled
1288: AND paa.enable_vmi_flag = 'Y'

Line 1285: AND p_type_lookup_code_tbl(i) = c_STANDARD

1281: WHERE
1282: -- item is not null
1283: p_item_id_tbl(i) IS NOT NULL
1284: -- Document is standard PO
1285: AND p_type_lookup_code_tbl(i) = c_STANDARD
1286:
1287: --VMI is enabled
1288: AND paa.enable_vmi_flag = 'Y'
1289: AND pasl.item_id = p_item_id_tbl(i)

Line 2460: AND PLL.shipment_type = c_STANDARD

2456: FROM PO_LINE_LOCATIONS_ALL PLL
2457: WHERE PLL.po_line_id = p_line_id_tbl(i)
2458: AND PLL.payment_type = c_MILESTONE
2459: AND PLL.value_basis = c_QUANTITY
2460: AND PLL.shipment_type = c_STANDARD
2461: )
2462: ) POLL_TOTAL, PO_LINES_ALL POL
2463: WHERE
2464: POL.po_line_id = p_line_id_tbl(i)

Line 2549: AND PLL.shipment_type = c_STANDARD

2545: FROM PO_LINE_LOCATIONS_ALL PLL
2546: WHERE PLL.po_line_id = p_line_id_tbl(i)
2547: AND PLL.payment_type = c_MILESTONE
2548: AND PLL.value_basis = c_QUANTITY
2549: AND PLL.shipment_type = c_STANDARD
2550: ) POLL_TOTAL, PO_LINES_ALL POL
2551: WHERE
2552: POL.po_line_id = p_line_id_tbl(i)
2553: AND p_price_tbl(i) IS NOT NULL

Line 4754: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD

4750:
4751: FOR i IN 1..p_intf_line_id_tbl.Count
4752: LOOP
4753: IF PO_PDOI_PARAMS.g_request.document_type <>
4754: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
4755: THEN
4756: BEGIN
4757: SELECT 'Y' INTO is_valid_idc_type
4758: FROM dual

Line 4914: AND phd.type_lookup_code = 'STANDARD'

4910: l_data_key,
4911: p_intf_line_id_tbl(i)
4912: FROM po_headers_draft_all phd, po_headers_interface phi, po_lines_interface pli
4913: WHERE phd.po_header_id = phi.po_header_id
4914: AND phd.type_lookup_code = 'STANDARD'
4915: AND phi.interface_header_id = PLI.interface_header_id
4916: AND PLI.interface_line_id = p_intf_line_id_tbl(i)
4917: AND Nvl(phd.clm_source_document_id,-1) <> Nvl(p_from_header_id_tbl(i),-1);
4918: