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_DATA_UTIL dependencies on PO_LINES_ALL

Line 2854: l_contract_type PO_LINES_ALL.CONTRACT_TYPE%TYPE;

2850:
2851: l_po_uda_usage_object po_uda_usage_object ;
2852: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
2853: l_attr_grp_ids_list PO_TBL_NUMBER;
2854: l_contract_type PO_LINES_ALL.CONTRACT_TYPE%TYPE;
2855: l_clm_idc_type PO_LINES_ALL.CLM_IDC_TYPE%TYPE;
2856: l_x_attr_ids_count NUMBER;
2857: l_attr_grp_ids PO_TBL_NUMBER;
2858: t_count NUMBER;

Line 2855: l_clm_idc_type PO_LINES_ALL.CLM_IDC_TYPE%TYPE;

2851: l_po_uda_usage_object po_uda_usage_object ;
2852: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
2853: l_attr_grp_ids_list PO_TBL_NUMBER;
2854: l_contract_type PO_LINES_ALL.CONTRACT_TYPE%TYPE;
2855: l_clm_idc_type PO_LINES_ALL.CLM_IDC_TYPE%TYPE;
2856: l_x_attr_ids_count NUMBER;
2857: l_attr_grp_ids PO_TBL_NUMBER;
2858: t_count NUMBER;
2859: l_count NUMBER;

Line 2882: FROM po_lines_all

2878: IF (c_get_usages_rec.attribute_category = 'PRICING') then
2879: IF(p_draft_id = -1) THEN
2880: SELECT CONTRACT_TYPE, CLM_IDC_TYPE
2881: INTO l_contract_type ,l_clm_idc_type
2882: FROM po_lines_all
2883: WHERE po_line_id = p_po_line_id;
2884: ELSE
2885: SELECT CONTRACT_TYPE, CLM_IDC_TYPE
2886: INTO l_contract_type ,l_clm_idc_type

Line 3039: INSERT INTO po_lines_all_ext_b DESTlINE

3035:
3036: IF(p_draft_id > 0) THEN
3037:
3038: FORALL i IN 1..po_dest_line_ids_tbl.Count
3039: INSERT INTO po_lines_all_ext_b DESTlINE
3040: (DESTLINE.extension_id,
3041: DESTLINE.attr_group_id,
3042: DESTLINE.po_line_id,
3043: DESTLINE.data_level_id,

Line 3253: FROM po_lines_all_ext_b SRCLINE WHERE SRCLINE.po_line_id = po_src_line_id AND draft_id = -1

3249: SRCLINE.d_ext_attr9,
3250: SRCLINE.d_ext_attr10,
3251: SRCLINE.uda_template_id,
3252: SRCLINE.draft_id
3253: FROM po_lines_all_ext_b SRCLINE WHERE SRCLINE.po_line_id = po_src_line_id AND draft_id = -1
3254: AND NOT EXISTS (SELECT 1 FROM po_lines_all_ext_b pleb WHERE
3255: pleb.po_line_id =po_dest_line_ids_tbl(i) AND
3256: pleb.attr_group_id = SRCLINE.attr_group_id AND
3257: pleb.draft_id = p_draft_id);

Line 3254: AND NOT EXISTS (SELECT 1 FROM po_lines_all_ext_b pleb WHERE

3250: SRCLINE.d_ext_attr10,
3251: SRCLINE.uda_template_id,
3252: SRCLINE.draft_id
3253: FROM po_lines_all_ext_b SRCLINE WHERE SRCLINE.po_line_id = po_src_line_id AND draft_id = -1
3254: AND NOT EXISTS (SELECT 1 FROM po_lines_all_ext_b pleb WHERE
3255: pleb.po_line_id =po_dest_line_ids_tbl(i) AND
3256: pleb.attr_group_id = SRCLINE.attr_group_id AND
3257: pleb.draft_id = p_draft_id);
3258: END IF ;

Line 3262: 'MERGE INTO po_lines_all_ext_b DESTLINE

3258: END IF ;
3259:
3260: mergeStmt := mergeStmt ||
3261:
3262: 'MERGE INTO po_lines_all_ext_b DESTLINE
3263: USING (
3264: SELECT
3265: attr_group_id,
3266: po_line_id,

Line 3370: FROM po_lines_all_ext_b WHERE po_line_id = ' || po_src_line_id || ' and draft_id = ' || p_draft_id || ' ) SRCLINE

3366: d_ext_attr9,
3367: d_ext_attr10,
3368: uda_template_id,
3369: draft_id
3370: FROM po_lines_all_ext_b WHERE po_line_id = ' || po_src_line_id || ' and draft_id = ' || p_draft_id || ' ) SRCLINE
3371: ON
3372: (DESTLINE.po_line_id IN (' || po_dest_line_ids || ') AND DESTLINE.attr_group_id = SRCLINE.attr_group_id AND DESTLINE.draft_id = '|| p_draft_id ||')
3373: WHEN MATCHED THEN
3374: UPDATE

Line 3480: INSERT INTO po_lines_all_ext_b DESTlINE

3476: d_progress := '30';
3477:
3478: FORALL i IN 1..po_dest_line_ids_tbl.Count
3479:
3480: INSERT INTO po_lines_all_ext_b DESTlINE
3481: (DESTLINE.extension_id,
3482: DESTLINE.attr_group_id,
3483: DESTLINE.po_line_id,
3484: DESTLINE.data_level_id,

Line 3694: FROM po_lines_all_ext_b SRCLINE WHERE SRCLINE.po_line_id = po_src_line_id AND draft_id = p_draft_id

3690: SRCLINE.d_ext_attr9,
3691: SRCLINE.d_ext_attr10,
3692: SRCLINE.uda_template_id,
3693: SRCLINE.draft_id
3694: FROM po_lines_all_ext_b SRCLINE WHERE SRCLINE.po_line_id = po_src_line_id AND draft_id = p_draft_id
3695: AND NOT EXISTS (SELECT 1 FROM po_lines_all_ext_b pleb WHERE
3696: pleb.po_line_id =po_dest_line_ids_tbl(i) AND
3697: pleb.attr_group_id = SRCLINE.attr_group_id AND
3698: pleb.draft_id = SRCLINE.draft_id);

Line 3695: AND NOT EXISTS (SELECT 1 FROM po_lines_all_ext_b pleb WHERE

3691: SRCLINE.d_ext_attr10,
3692: SRCLINE.uda_template_id,
3693: SRCLINE.draft_id
3694: FROM po_lines_all_ext_b SRCLINE WHERE SRCLINE.po_line_id = po_src_line_id AND draft_id = p_draft_id
3695: AND NOT EXISTS (SELECT 1 FROM po_lines_all_ext_b pleb WHERE
3696: pleb.po_line_id =po_dest_line_ids_tbl(i) AND
3697: pleb.attr_group_id = SRCLINE.attr_group_id AND
3698: pleb.draft_id = SRCLINE.draft_id);
3699:

Line 3704: FROM po_lines_all_ext_b

3700:
3701: d_progress := '40';
3702: selectStmt := selectStmt ||
3703: ' SELECT extension_id,attr_group_id,po_line_id,data_level_id,uda_template_id
3704: FROM po_lines_all_ext_b
3705: WHERE po_line_id IN ( ' || po_dest_line_ids || ') AND draft_id = '|| p_draft_id;
3706:
3707: d_progress := '50';
3708:

Line 3715: INSERT INTO po_lines_all_ext_tl

3711: d_progress := '60';
3712:
3713:
3714: FORALL i IN 1..extension_id_tbl.Count
3715: INSERT INTO po_lines_all_ext_tl
3716: (
3717: EXTENSION_ID,
3718: ATTR_GROUP_ID,
3719: PO_LINE_ID,

Line 3750: (SELECT 1 FROM po_lines_all_ext_tl pltl WHERE

3746:
3747: FROM FND_LANGUAGES L
3748: WHERE L.INSTALLED_FLAG in ('I', 'B')
3749: AND NOT EXISTS
3750: (SELECT 1 FROM po_lines_all_ext_tl pltl WHERE
3751: pltl.extension_id = extension_id_tbl(i)
3752: AND pltl.LANGUAGE = L.LANGUAGE_CODE);
3753:
3754: d_progress := '70';

Line 3756: DELETE FROM po_lines_all_ext_b WHERE po_line_id = po_src_line_id AND draft_id = p_draft_id;

3752: AND pltl.LANGUAGE = L.LANGUAGE_CODE);
3753:
3754: d_progress := '70';
3755:
3756: DELETE FROM po_lines_all_ext_b WHERE po_line_id = po_src_line_id AND draft_id = p_draft_id;
3757:
3758: d_progress := '80';
3759:
3760: EXCEPTION

Line 4757: g_object_dff_tl('PO_LINE_EXT_ATTRS').l_object_name := 'PO_LINES_ALL' ;

4753: g_object_dff_tl('PO_HEADER_EXT_ATTRS').l_object_ext_tl_table := 'PO_HEADERS_ALL_EXT_TL';
4754: g_object_dff_tl('PO_HEADER_EXT_ATTRS').l_ag_mapping_column := 'PO_HEADER_GROUP_ID';
4755: g_object_dff_tl('PO_HEADER_EXT_ATTRS').l_arch_object_name := 'PO_HEADERS_ARCHIVE_ALL' ;
4756:
4757: g_object_dff_tl('PO_LINE_EXT_ATTRS').l_object_name := 'PO_LINES_ALL' ;
4758: g_object_dff_tl('PO_LINE_EXT_ATTRS').l_dff_name := 'PO_LINE_EXT_ATTRS';
4759: g_object_dff_tl('PO_LINE_EXT_ATTRS').l_object_ext_b_table := 'PO_LINES_ALL_EXT_B';
4760: g_object_dff_tl('PO_LINE_EXT_ATTRS').l_object_ext_tl_table := 'PO_LINES_ALL_EXT_TL';
4761: g_object_dff_tl('PO_LINE_EXT_ATTRS').l_ag_mapping_column := 'PO_LINE_GROUP_ID';

Line 4759: g_object_dff_tl('PO_LINE_EXT_ATTRS').l_object_ext_b_table := 'PO_LINES_ALL_EXT_B';

4755: g_object_dff_tl('PO_HEADER_EXT_ATTRS').l_arch_object_name := 'PO_HEADERS_ARCHIVE_ALL' ;
4756:
4757: g_object_dff_tl('PO_LINE_EXT_ATTRS').l_object_name := 'PO_LINES_ALL' ;
4758: g_object_dff_tl('PO_LINE_EXT_ATTRS').l_dff_name := 'PO_LINE_EXT_ATTRS';
4759: g_object_dff_tl('PO_LINE_EXT_ATTRS').l_object_ext_b_table := 'PO_LINES_ALL_EXT_B';
4760: g_object_dff_tl('PO_LINE_EXT_ATTRS').l_object_ext_tl_table := 'PO_LINES_ALL_EXT_TL';
4761: g_object_dff_tl('PO_LINE_EXT_ATTRS').l_ag_mapping_column := 'PO_LINE_GROUP_ID';
4762: g_object_dff_tl('PO_LINE_EXT_ATTRS').l_arch_object_name := 'PO_LINES_ARCHIVE_ALL' ;
4763:

Line 4760: g_object_dff_tl('PO_LINE_EXT_ATTRS').l_object_ext_tl_table := 'PO_LINES_ALL_EXT_TL';

4756:
4757: g_object_dff_tl('PO_LINE_EXT_ATTRS').l_object_name := 'PO_LINES_ALL' ;
4758: g_object_dff_tl('PO_LINE_EXT_ATTRS').l_dff_name := 'PO_LINE_EXT_ATTRS';
4759: g_object_dff_tl('PO_LINE_EXT_ATTRS').l_object_ext_b_table := 'PO_LINES_ALL_EXT_B';
4760: g_object_dff_tl('PO_LINE_EXT_ATTRS').l_object_ext_tl_table := 'PO_LINES_ALL_EXT_TL';
4761: g_object_dff_tl('PO_LINE_EXT_ATTRS').l_ag_mapping_column := 'PO_LINE_GROUP_ID';
4762: g_object_dff_tl('PO_LINE_EXT_ATTRS').l_arch_object_name := 'PO_LINES_ARCHIVE_ALL' ;
4763:
4764: g_object_dff_tl('PO_SHIPMENTS_EXT_ATTRS').l_object_name := 'PO_LINE_LOCATIONS_ALL' ;