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_UDA_IMPORT_PKG dependencies on PO_LINES_ALL_EXT_B

Line 2368: FROM po_lines_all_ext_b plaeb

2364: IF l_matching_basis = 'AMOUNT' THEN
2365: UPDATE po_lines_draft_all plda
2366: SET (plda.CLM_UDA_PRICING_TOTAL , plda.amount) =
2367: (SELECT plaeb.N_EXT_ATTR20,(plaeb.N_EXT_ATTR20 + Nvl(plda.CLM_APPROVED_UNDEF_AMOUNT,0))-- + plu.undef_amount)
2368: FROM po_lines_all_ext_b plaeb
2369: WHERE plaeb.draft_id = Decode(l_draft_id_tbl(i),p_draft_id,p_draft_id,-1)
2370: AND plaeb.attr_group_id = l_attr_group_id_tbl(i)
2371: AND plaeb.po_line_id = l_po_lines_tbl(i) )
2372: WHERE plda.draft_id = p_draft_id

Line 2411: FROM po_lines_all_ext_b plaeb

2407: ELSE
2408: UPDATE po_lines_draft_all plda
2409: SET (plda.CLM_UDA_PRICING_TOTAL,plda.quantity) =
2410: (SELECT plaeb.N_EXT_ATTR20,(plaeb.N_EXT_ATTR20 + Nvl(plda.CLM_APPROVED_UNDEF_AMOUNT,0))-- + plu.undef_amount)
2411: FROM po_lines_all_ext_b plaeb
2412: WHERE plaeb.draft_id = Decode(l_draft_id_tbl(i),p_draft_id,p_draft_id,-1)
2413: AND plaeb.attr_group_id = l_attr_group_id_tbl(i)
2414: AND plaeb.po_line_id = l_po_lines_tbl(i) )
2415: WHERE plda.draft_id = p_draft_id

Line 2465: --Need to check if delta record already exists in po_lines_all_ext_b

2461: THEN
2462:
2463: BEGIN
2464:
2465: --Need to check if delta record already exists in po_lines_all_ext_b
2466: --If the record exists, then the record needs to be updated
2467: --If record doesnt exist, then insert a new record in po_lines_all_ext_b
2468: SELECT 'Y'
2469: INTO l_records_exist

Line 2467: --If record doesnt exist, then insert a new record in po_lines_all_ext_b

2463: BEGIN
2464:
2465: --Need to check if delta record already exists in po_lines_all_ext_b
2466: --If the record exists, then the record needs to be updated
2467: --If record doesnt exist, then insert a new record in po_lines_all_ext_b
2468: SELECT 'Y'
2469: INTO l_records_exist
2470: FROM dual
2471: WHERE EXISTS ( SELECT 1

Line 2473: po_lines_all_ext_b

2469: INTO l_records_exist
2470: FROM dual
2471: WHERE EXISTS ( SELECT 1
2472: FROM
2473: po_lines_all_ext_b
2474: WHERE draft_id = l_draft_id_tbl(i)
2475: AND attr_group_id = l_attr_group_id_tbl(i)
2476: AND po_line_id = l_po_lines_tbl(i)
2477: AND data_level_id = (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_DELTA_ARCHIVE'));

Line 2498: -- po_lines_all_ext_b and po_lines_all_ext_tl.

2494: FROM fnd_languages
2495: WHERE INSTALLED_FLAG in ('I', 'B');
2496:
2497: --The import UDA api doesnt take care of inserting delta archove and old archive record in
2498: -- po_lines_all_ext_b and po_lines_all_ext_tl.
2499: -- So these records are inserted / updated here
2500: -- Update the existing record if record exists
2501: IF l_records_exist = 'Y'
2502: THEN

Line 2503: UPDATE po_lines_all_ext_b

2499: -- So these records are inserted / updated here
2500: -- Update the existing record if record exists
2501: IF l_records_exist = 'Y'
2502: THEN
2503: UPDATE po_lines_all_ext_b
2504: SET (EXTENSION_ID
2505: ,ATTR_GROUP_ID
2506: ,PO_LINE_ID
2507: ,DATA_LEVEL_ID

Line 2718: FROM PO_LINES_ALL_EXT_B pl_old,PO_LINES_ALL_EXT_B pl_new

2714: ,pl_new.D_EXT_ATTR9
2715: ,pl_new.D_EXT_ATTR10
2716: ,pl_old.UDA_TEMPLATE_ID
2717: ,l_draft_id_tbl(i) * -1
2718: FROM PO_LINES_ALL_EXT_B pl_old,PO_LINES_ALL_EXT_B pl_new
2719: WHERE pl_old.po_line_id = pl_new.po_line_id
2720: AND pl_old.ATTR_GROUP_ID = pl_new.ATTR_GROUP_ID
2721: AND pl_old.data_level_id = pl_new.data_level_id
2722: AND pl_old.ATTR_GROUP_ID = l_attr_group_id_tbl(i)

Line 2733: po_lines_all_ext_b

2729:
2730: -- record doesnt exist in po_headers_all_ext_b table, so insert new record
2731: --inset delta archive record
2732: INSERT INTO
2733: po_lines_all_ext_b
2734: (EXTENSION_ID
2735: ,ATTR_GROUP_ID
2736: ,PO_LINE_ID
2737: ,DATA_LEVEL_ID

Line 2948: FROM PO_LINES_ALL_EXT_B pl_old,PO_LINES_ALL_EXT_B pl_new

2944: ,pl_new.D_EXT_ATTR9
2945: ,pl_new.D_EXT_ATTR10
2946: ,pl_old.UDA_TEMPLATE_ID
2947: ,l_draft_id_tbl(i) * -1
2948: FROM PO_LINES_ALL_EXT_B pl_old,PO_LINES_ALL_EXT_B pl_new
2949: WHERE pl_old.po_line_id = pl_new.po_line_id
2950: AND pl_old.ATTR_GROUP_ID = pl_new.ATTR_GROUP_ID
2951: AND pl_old.data_level_id = pl_new.data_level_id
2952: AND pl_old.ATTR_GROUP_ID = l_attr_group_id_tbl(i)

Line 2960: po_lines_all_ext_b

2956: AND pl_old.draft_id = -1;
2957:
2958: --insert old archive record
2959: INSERT INTO
2960: po_lines_all_ext_b
2961: (EXTENSION_ID
2962: ,ATTR_GROUP_ID
2963: ,PO_LINE_ID
2964: ,DATA_LEVEL_ID

Line 3175: FROM PO_LINES_ALL_EXT_B pl_old,PO_LINES_ALL_EXT_B pl_new

3171: ,pl_old.D_EXT_ATTR9
3172: ,pl_old.D_EXT_ATTR10
3173: ,pl_old.UDA_TEMPLATE_ID
3174: , -1
3175: FROM PO_LINES_ALL_EXT_B pl_old,PO_LINES_ALL_EXT_B pl_new
3176: WHERE pl_old.po_line_id = pl_new.po_line_id
3177: AND pl_old.ATTR_GROUP_ID = pl_new.ATTR_GROUP_ID
3178: AND pl_old.data_level_id = pl_new.data_level_id
3179: AND pl_old.ATTR_GROUP_ID = l_attr_group_id_tbl(i)

Line 3187: -- Inserting/Updating records in po_lines_all_ext_b table

3183: AND pl_old.draft_id = -1;
3184:
3185: END IF;
3186:
3187: -- Inserting/Updating records in po_lines_all_ext_b table
3188: FOR j IN 1..l_language_code_tbl.Count()
3189: LOOP
3190:
3191: --Update delta archive record in po_lines_all_ext_tl

Line 3226: FROM po_lines_all_ext_b

3222: 0,
3223: SYSDATE,
3224: UDA_TEMPLATE_ID,
3225: draft_id
3226: FROM po_lines_all_ext_b
3227: WHERE ATTR_GROUP_ID = l_attr_group_id_tbl(i)
3228: AND PO_LINE_ID = -1* l_po_lines_tbl(i)
3229: AND draft_id = l_draft_id_tbl(i) * -1
3230: AND data_level_id = (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_DELTA_ARCHIVE'));

Line 3267: FROM po_lines_all_ext_b

3263: 0,
3264: SYSDATE,
3265: UDA_TEMPLATE_ID,
3266: draft_id
3267: FROM po_lines_all_ext_b
3268: WHERE ATTR_GROUP_ID = l_attr_group_id_tbl(i)
3269: AND PO_LINE_ID = -1* l_po_lines_tbl(i)
3270: AND draft_id = l_draft_id_tbl(i) * -1
3271: AND data_level_id = (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_DELTA_ARCHIVE');

Line 3307: FROM po_lines_all_ext_b

3303: 0,
3304: SYSDATE,
3305: UDA_TEMPLATE_ID,
3306: draft_id
3307: FROM po_lines_all_ext_b
3308: WHERE ATTR_GROUP_ID = l_attr_group_id_tbl(i)
3309: AND PO_LINE_ID = l_po_lines_tbl(i)
3310: AND draft_id = -1
3311: AND data_level_id = (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_OLD_ARCHIVE');