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_DIFF_SUMMARY_PKG dependencies on PO_ATTRIBUTE_VALUES

Line 829: FROM po_attribute_values_draft

825: AND PDD.draft_id = LLD.draft_id(+)
826: AND PDD.entity_id = LL.line_location_id(+)
827: UNION
828: SELECT po_line_id
829: FROM po_attribute_values_draft
830: WHERE draft_id = l_draft_id
831: AND change_accepted_flag IS NULL
832: UNION
833: SELECT po_line_id

Line 834: FROM po_attribute_values_tlp_draft

830: WHERE draft_id = l_draft_id
831: AND change_accepted_flag IS NULL
832: UNION
833: SELECT po_line_id
834: FROM po_attribute_values_tlp_draft
835: WHERE draft_id = l_draft_id
836: AND language = l_created_language
837: AND change_accepted_flag IS NULL
838: );

Line 915: FROM po_attribute_values_draft

911: WHERE draft_id = l_draft_id
912: AND change_accepted_flag = 'N')
913: OR EXISTS
914: (SELECT 1
915: FROM po_attribute_values_draft
916: WHERE draft_id = l_draft_id
917: AND change_accepted_flag = 'N');
918: EXCEPTION
919: WHEN NO_DATA_FOUND THEN

Line 1686: UPDATE po_attribute_values_tlp_draft PAVTD

1682: po_headers_all PH
1683: WHERE DFT.draft_id = p_draft_id
1684: AND PH.po_header_id = DFT.document_id;
1685:
1686: UPDATE po_attribute_values_tlp_draft PAVTD
1687: SET change_accepted_flag = 'Y'
1688: WHERE change_accepted_flag IS NULL
1689: AND PAVTD.draft_id = p_draft_id
1690: AND PAVTD.language <> l_created_language;

Line 1784: UPDATE po_attribute_values_draft PAVD

1780:
1781: d_position := 30;
1782:
1783: -- Attr Values Level
1784: UPDATE po_attribute_values_draft PAVD
1785: SET PAVD.change_accepted_flag = 'Y'
1786: WHERE PAVD.draft_id = p_draft_id
1787: AND PAVD.change_accepted_flag IS NULL
1788: AND PAVD.delete_flag = 'Y'

Line 1791: FROM po_attribute_values PAV

1787: AND PAVD.change_accepted_flag IS NULL
1788: AND PAVD.delete_flag = 'Y'
1789: AND NOT EXISTS
1790: ( SELECT 1
1791: FROM po_attribute_values PAV
1792: WHERE PAVD.attribute_values_id = PAV.attribute_values_id);
1793:
1794: d_position := 40;
1795:

Line 1797: UPDATE po_attribute_values_tlp_draft PAVTD

1793:
1794: d_position := 40;
1795:
1796: -- Attr Values TLP Level
1797: UPDATE po_attribute_values_tlp_draft PAVTD
1798: SET PAVTD.change_accepted_flag = 'Y'
1799: WHERE PAVTD.draft_id = p_draft_id
1800: AND PAVTD.change_accepted_flag IS NULL
1801: AND PAVTD.delete_flag = 'Y'

Line 1804: FROM po_attribute_values_tlp PAVT

1800: AND PAVTD.change_accepted_flag IS NULL
1801: AND PAVTD.delete_flag = 'Y'
1802: AND NOT EXISTS
1803: ( SELECT 1
1804: FROM po_attribute_values_tlp PAVT
1805: WHERE PAVTD.attribute_values_tlp_id = PAVT.attribute_values_tlp_id);
1806:
1807: IF (PO_LOG.d_proc) THEN
1808: PO_LOG.proc_end (d_module);

Line 1993: UPDATE po_attribute_values_draft PAVD

1989:
1990: d_position := 30;
1991:
1992: -- Attribute Values
1993: UPDATE po_attribute_values_draft PAVD
1994: SET PAVD.change_accepted_flag = 'Y'
1995: WHERE PAVD.draft_id = p_draft_id
1996: AND PAVD.change_accepted_flag IS NULL
1997: AND NVL(PAVD.delete_flag, 'N') <> 'Y'

Line 2000: FROM po_attribute_values PAV

1996: AND PAVD.change_accepted_flag IS NULL
1997: AND NVL(PAVD.delete_flag, 'N') <> 'Y'
1998: AND EXISTS
1999: ( SELECT 1
2000: FROM po_attribute_values PAV
2001: WHERE PAVD.attribute_values_id = PAV.attribute_values_id
2002: AND DECODE (PAVD.manufacturer_part_num ,
2003: PAV.manufacturer_part_num , 'Y', 'N') = 'Y'
2004: AND DECODE (PAVD.picture,

Line 2629: UPDATE po_attribute_values_tlp_draft PAVTD

2625:
2626: d_position := 40;
2627:
2628: -- Attribute values tlp
2629: UPDATE po_attribute_values_tlp_draft PAVTD
2630: SET PAVTD.change_accepted_flag = 'Y'
2631: WHERE PAVTD.draft_id = p_draft_id
2632: AND PAVTD.change_accepted_flag IS NULL
2633: AND NVL(PAVTD.delete_flag, 'N') <> 'Y'

Line 2636: FROM po_attribute_values_tlp PAVT

2632: AND PAVTD.change_accepted_flag IS NULL
2633: AND NVL(PAVTD.delete_flag, 'N') <> 'Y'
2634: AND EXISTS
2635: ( SELECT 1
2636: FROM po_attribute_values_tlp PAVT
2637: WHERE PAVTD.attribute_values_tlp_id = PAVT.attribute_values_tlp_id
2638: AND DECODE (PAVTD.description,
2639: PAVT.description, 'Y', 'N') = 'Y'
2640: AND DECODE (PAVTD.manufacturer,

Line 3035: FROM po_attribute_values_draft

3031: WHERE draft_id = p_draft_id
3032: AND change_accepted_flag IS NULL)
3033: OR EXISTS
3034: ( SELECT 1
3035: FROM po_attribute_values_draft
3036: WHERE draft_id = p_draft_id
3037: AND change_accepted_flag IS NULL)
3038: OR EXISTS
3039: ( SELECT 1

Line 3040: FROM po_attribute_values_tlp_draft

3036: WHERE draft_id = p_draft_id
3037: AND change_accepted_flag IS NULL)
3038: OR EXISTS
3039: ( SELECT 1
3040: FROM po_attribute_values_tlp_draft
3041: WHERE draft_id = p_draft_id
3042: AND change_accepted_flag IS NULL);
3043:
3044:

Line 3115: UPDATE po_attribute_values_draft PLVD

3111: AND PLDA.draft_id = PLLDA.draft_id );
3112:
3113: d_position := 10;
3114:
3115: UPDATE po_attribute_values_draft PLVD
3116: SET PLVD.change_accepted_flag = 'Y'
3117: WHERE PLVD.draft_id = p_draft_id
3118: AND NVL(PLVD.change_accepted_flag, 'N') <> 'Y'
3119: AND NOT EXISTS

Line 3127: UPDATE po_attribute_values_tlp_draft PLVTD

3123: AND PLDA.draft_id = PLVD.draft_id );
3124:
3125: d_position := 20;
3126:
3127: UPDATE po_attribute_values_tlp_draft PLVTD
3128: SET PLVTD.change_accepted_flag = 'Y'
3129: WHERE PLVTD.draft_id = p_draft_id
3130: AND NVL(PLVTD.change_accepted_flag, 'N') <> 'Y'
3131: AND NOT EXISTS

Line 3248: UPDATE po_attribute_values_draft

3244: d_position := 20;
3245:
3246: -- attribute values
3247: FORALL i IN 1..p_line_id_list.COUNT
3248: UPDATE po_attribute_values_draft
3249: SET change_accepted_flag = p_change_accepted_value
3250: WHERE draft_id = p_draft_id
3251: AND po_line_id = p_line_id_list(i);
3252:

Line 3257: UPDATE po_attribute_values_tlp_draft

3253: d_position := 30;
3254:
3255: -- attribute values tlp
3256: FORALL i IN 1..p_line_id_list.COUNT
3257: UPDATE po_attribute_values_tlp_draft
3258: SET change_accepted_flag = p_change_accepted_value
3259: WHERE draft_id = p_draft_id
3260: AND po_line_id = p_line_id_list(i);
3261:

Line 3557: FROM po_attribute_values_draft

3553: FROM po_price_diff_draft
3554: WHERE draft_id = l_draft_id
3555: AND nvl(change_accepted_flag,'Y') = 'Y')
3556: OR EXISTS (SELECT 1
3557: FROM po_attribute_values_draft
3558: WHERE draft_id = l_draft_id
3559: AND nvl(change_accepted_flag,'Y') = 'Y');
3560:
3561: EXCEPTION