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_LINES2 dependencies on PO_LINES

Line 2296: FROM po_lines_all pln

2292: FROM DUAL
2293: WHERE p_po_header_id_tbl(i) IS NOT NULL
2294: AND p_line_num_tbl(i) IS NOT NULL
2295: AND (EXISTS(SELECT 'Y'
2296: FROM po_lines_all pln
2297: WHERE pln.po_header_id = p_po_header_id_tbl(i)
2298: AND pln.line_num = p_line_num_tbl(i)
2299: AND NOT EXISTS (SELECT 'Y'
2300: FROM po_lines_draft_all PLD

Line 2300: FROM po_lines_draft_all PLD

2296: FROM po_lines_all pln
2297: WHERE pln.po_header_id = p_po_header_id_tbl(i)
2298: AND pln.line_num = p_line_num_tbl(i)
2299: AND NOT EXISTS (SELECT 'Y'
2300: FROM po_lines_draft_all PLD
2301: WHERE PLN.po_line_id = PLD.po_line_id
2302: AND PLD.draft_id = p_draft_id_tbl(i)))
2303: OR
2304: EXISTS (SELECT 'Y'

Line 2305: FROM po_lines_draft_all PLD

2301: WHERE PLN.po_line_id = PLD.po_line_id
2302: AND PLD.draft_id = p_draft_id_tbl(i)))
2303: OR
2304: EXISTS (SELECT 'Y'
2305: FROM po_lines_draft_all PLD
2306: WHERE PLD.draft_id = p_draft_id_tbl(i)
2307: AND PLD.po_header_id = p_po_header_id_tbl(i)
2308: AND PLD.line_num = p_line_num_tbl(i)
2309: AND NVL(PLD.delete_flag, 'N') <> 'Y'));

Line 2384: FROM po_lines pln

2380: FROM DUAL
2381: WHERE p_po_line_id_tbl(i) IS NULL
2382: OR ( p_po_header_id_tbl(i) IS NOT NULL
2383: AND EXISTS(SELECT 1
2384: FROM po_lines pln
2385: WHERE pln.po_header_id = p_po_header_id_tbl(i)
2386: AND pln.po_line_id = p_po_line_id_tbl(i)));
2387:
2388: IF (SQL%ROWCOUNT > 0) THEN

Line 3225: -- We need to validate UOM against po_lines_all and po_units_of_measure_val_v

3221: RAISE;
3222: END ip_category_id_update;
3223:
3224: -----------------------------------------------------------------------------
3225: -- We need to validate UOM against po_lines_all and po_units_of_measure_val_v
3226: -----------------------------------------------------------------------------
3227: PROCEDURE uom_update(
3228: p_id_tbl IN po_tbl_number,
3229: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,

Line 3291: FROM po_lines_all pol,

3287: PO_VAL_CONSTANTS.c_uom_update_valid
3288: FROM DUAL
3289: WHERE EXISTS(
3290: SELECT 1
3291: FROM po_lines_all pol,
3292: po_units_of_measure_val_v pumv
3293: WHERE po_header_id = p_po_header_id_tbl(i) AND
3294: po_line_id = p_po_line_id_tbl(i) AND
3295: p_unit_meas_lookup_code_tbl(i) IS NOT NULL AND

Line 3301: FROM po_lines_all pol,

3297: p_unit_meas_lookup_code_tbl(i)) AND
3298: pumv.unit_of_measure <> p_unit_meas_lookup_code_tbl(i))
3299: OR EXISTS(
3300: SELECT 1
3301: FROM po_lines_all pol,
3302: po_units_of_measure_val_v pumv
3303: WHERE p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE') AND
3304: po_header_id = p_po_header_id_tbl(i) AND
3305: po_line_id = p_po_line_id_tbl(i) AND

Line 3330: -- Also need to check the value in po_lines_all to make sure it is the same there, if necessary.

3326:
3327: -------------------------------------------------------------------------
3328: -- Make sure that the item_description can be different from what is setup in the item master.
3329: -- Would not allow item_description update if item attribute allow_item_desc_update_flag is N.
3330: -- Also need to check the value in po_lines_all to make sure it is the same there, if necessary.
3331: -------------------------------------------------------------------------
3332: PROCEDURE item_desc_update(
3333: p_id_tbl IN po_tbl_number,
3334: p_item_description_tbl IN po_tbl_varchar2000,

Line 3402: po_lines_all pol,

3398: FROM DUAL
3399: WHERE EXISTS(
3400: SELECT 1
3401: FROM mtl_system_items msi,
3402: po_lines_all pol,
3403: mtl_system_items_tl mtl
3404: WHERE p_po_line_id_tbl(i) IS NOT NULL AND
3405: p_item_id_tbl(i) IS NOT NULL AND
3406: pol.po_header_id = nvl(p_po_header_id_tbl(i),pol.po_header_id) AND

Line 3627: FROM po_lines_all pol

3623: FROM DUAL
3624: WHERE p_category_id_tbl(i) IS NOT NULL
3625: AND (p_item_id_tbl(i) IS NOT NULL OR p_job_id_tbl(i) IS NOT NULL)
3626: AND (EXISTS(SELECT 1
3627: FROM po_lines_all pol
3628: WHERE p_po_line_id_tbl(i) = pol.po_line_id
3629: AND p_category_id_tbl(i) <> pol.category_id)
3630: OR EXISTS(SELECT 1
3631: FROM po_lines_draft_all pld

Line 3631: FROM po_lines_draft_all pld

3627: FROM po_lines_all pol
3628: WHERE p_po_line_id_tbl(i) = pol.po_line_id
3629: AND p_category_id_tbl(i) <> pol.category_id)
3630: OR EXISTS(SELECT 1
3631: FROM po_lines_draft_all pld
3632: WHERE p_po_line_id_tbl(i) = pld.po_line_id
3633: AND p_category_id_tbl(i) <> pld.category_id));
3634:
3635: IF (SQL%ROWCOUNT > 0) THEN

Line 3743: FROM po_lines_all POL

3739: 'PO_PDOI_SVC_NO_PRICE',
3740: 'UNIT_PRICE',
3741: p_unit_price_tbl(i),
3742: PO_VAL_CONSTANTS.c_unit_price_null
3743: FROM po_lines_all POL
3744: WHERE POL.po_line_id = p_po_line_id_tbl(i)
3745: AND POL.order_type_lookup_code = 'FIXED PRICE'
3746: AND p_unit_price_tbl(i) IS NOT NULL
3747: -- missin draft id

Line 3757: FROM po_lines_draft_all POL

3753: 'PO_PDOI_SVC_NO_PRICE',
3754: 'UNIT_PRICE',
3755: p_unit_price_tbl(i),
3756: PO_VAL_CONSTANTS.c_unit_price_null
3757: FROM po_lines_draft_all POL
3758: WHERE POL.po_line_id = p_po_line_id_tbl(i)
3759: AND POL.draft_id = p_draft_id_tbl(i)
3760: AND POL.order_type_lookup_code = 'FIXED PRICE'
3761: AND p_unit_price_tbl(i) IS NOT NULL;

Line 3795: FROM po_lines_all POL

3791: p_unit_price_tbl(i),
3792: 'UNIT_PRICE',
3793: p_unit_price_tbl(i),
3794: PO_VAL_CONSTANTS.c_not_to_exceed_price_valid
3795: FROM po_lines_all POL
3796: WHERE POL.po_line_id = p_po_line_id_tbl(i)
3797: AND POL.not_to_exceed_price < p_unit_price_tbl(i);
3798:
3799: IF (SQL%ROWCOUNT > 0) THEN

Line 3868: FROM po_lines_all POL

3864: 'PO_PDOI_SVC_BLKT_NO_AMT',
3865: 'AMOUNT',
3866: p_amount_tbl(i),
3867: PO_VAL_CONSTANTS.c_amount_blanket
3868: FROM po_lines_all POL
3869: WHERE POL.po_line_id = p_po_line_id_tbl(i)
3870: AND POL.order_type_lookup_code <> 'FIXED PRICE'
3871: AND p_amount_tbl(i) IS NOT NULL
3872: -- missin draft id

Line 3882: FROM po_lines_draft_all POL

3878: 'PO_PDOI_SVC_BLKT_NO_AMT',
3879: 'AMOUNT',
3880: p_amount_tbl(i),
3881: PO_VAL_CONSTANTS.c_amount_blanket
3882: FROM po_lines_draft_all POL
3883: WHERE POL.po_line_id = p_po_line_id_tbl(i)
3884: AND POL.draft_id = p_draft_id_tbl(i)
3885: AND POL.order_type_lookup_code <> 'FIXED PRICE'
3886: AND p_amount_tbl(i) IS NOT NULL;