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_LINES_DRAFT_ALL

Line 802: FROM po_lines_draft_all

798: INTO l_reject_list
799: FROM
800: (
801: SELECT po_line_id
802: FROM po_lines_draft_all
803: WHERE draft_id = l_draft_id
804: AND change_accepted_flag IS NULL
805: UNION
806: SELECT po_line_id

Line 900: FROM po_lines_draft_all

896: INTO l_any_lines_get_rejected
897: FROM DUAL
898: WHERE EXISTS
899: (SELECT 1
900: FROM po_lines_draft_all
901: WHERE draft_id = l_draft_id
902: AND change_accepted_flag = 'N')
903: OR EXISTS
904: (SELECT 1

Line 1527: po_lines_draft_all PLD,

1523: l_new_price_tbl,
1524: l_old_price_tbl,
1525: l_new_line_flag_tbl
1526: FROM po_headers_all PH,
1527: po_lines_draft_all PLD,
1528: po_lines_all PL
1529: WHERE PLD.draft_id = p_draft_id
1530: AND NVL(PLD.delete_flag, 'N') = 'N'
1531: AND PLD.change_accepted_flag IS NULL

Line 1719: UPDATE po_lines_draft_all PLD

1715: PO_LOG.proc_begin (d_module);
1716: END IF;
1717:
1718: -- Line Level
1719: UPDATE po_lines_draft_all PLD
1720: SET PLD.change_accepted_flag = 'Y'
1721: WHERE PLD.draft_id = p_draft_id
1722: AND PLD.change_accepted_flag IS NULL
1723: AND PLD.delete_flag = 'Y'

Line 1838: UPDATE po_lines_draft_all PLD

1834: PO_LOG.proc_begin (d_module);
1835: END IF;
1836:
1837: -- Line Level Attributes
1838: UPDATE po_lines_draft_all PLD
1839: SET PLD.change_accepted_flag = 'Y'
1840: WHERE PLD.draft_id = p_draft_id
1841: AND PLD.change_accepted_flag IS NULL
1842: AND NVL(PLD.delete_flag, 'N') <> 'Y'

Line 2994: FROM po_lines_draft_all

2990: INTO l_has_record_to_accept
2991: FROM DUAL
2992: WHERE EXISTS
2993: ( SELECT 1
2994: FROM po_lines_draft_all
2995: WHERE draft_id = p_draft_id
2996: AND change_accepted_flag IS NULL)
2997: OR EXISTS
2998: ( SELECT 1

Line 3083: FROM po_lines_draft_all PLDA

3079: WHERE PLLDA.draft_id = p_draft_id
3080: AND NVL(PLLDA.change_accepted_flag, 'N') <> 'Y'
3081: AND NOT EXISTS
3082: ( SELECT NULL
3083: FROM po_lines_draft_all PLDA
3084: WHERE PLDA.po_line_id = PLLDA.po_line_id
3085: AND PLDA.draft_id = PLLDA.draft_id );
3086:
3087: d_position := 10;

Line 3095: FROM po_lines_draft_all PLDA

3091: WHERE PLVD.draft_id = p_draft_id
3092: AND NVL(PLVD.change_accepted_flag, 'N') <> 'Y'
3093: AND NOT EXISTS
3094: ( SELECT NULL
3095: FROM po_lines_draft_all PLDA
3096: WHERE PLDA.po_line_id = PLVD.po_line_id
3097: AND PLDA.draft_id = PLVD.draft_id );
3098:
3099: d_position := 20;

Line 3107: FROM po_lines_draft_all PLDA

3103: WHERE PLVTD.draft_id = p_draft_id
3104: AND NVL(PLVTD.change_accepted_flag, 'N') <> 'Y'
3105: AND NOT EXISTS
3106: ( SELECT NULL
3107: FROM po_lines_draft_all PLDA
3108: WHERE PLDA.po_line_id = PLVTD.po_line_id
3109: AND PLDA.draft_id = PLVTD.draft_id );
3110:
3111: d_position := 30;

Line 3120: FROM po_lines_draft_all PLDA

3116: AND NVL(PPDD.change_accepted_flag, 'N') <> 'Y'
3117: AND (( PPDD.entity_type = 'BLANKET LINE'
3118: AND NOT EXISTS
3119: ( SELECT NULL
3120: FROM po_lines_draft_all PLDA
3121: WHERE PLDA.po_line_id = PPDD.entity_id
3122: AND PLDA.draft_id = PPDD.draft_id
3123: )
3124: )

Line 3130: po_lines_draft_all PLDA

3126: ( PPDD.entity_type = 'PRICE BREAK'
3127: AND NOT EXISTS
3128: ( SELECT NULL
3129: FROM po_line_locations_draft_all PLLDA,
3130: po_lines_draft_all PLDA
3131: WHERE PLLDA.line_location_id = PPDD.entity_id
3132: AND PLLDA.draft_id = PPDD.draft_id
3133: AND PLDA.po_line_id = PLLDA.po_line_id
3134: AND PLDA.draft_id = PLLDA.draft_id )

Line 3138: po_lines_draft_all PLDA

3134: AND PLDA.draft_id = PLLDA.draft_id )
3135: AND NOT EXISTS
3136: ( SELECT NULL
3137: FROM po_line_locations_all PLLA,
3138: po_lines_draft_all PLDA
3139: WHERE PLLA.line_location_id = PPDD.entity_id
3140: AND PLDA.po_line_id = PLLA.po_line_id
3141: AND PLDA.draft_id = PPDD.draft_id)));
3142:

Line 3201: -- Update records in PO_LINES_DRAFT_ALL based on the list of lines to change

3197: END IF;
3198:
3199: x_return_status := FND_API.g_RET_STS_SUCCESS;
3200:
3201: -- Update records in PO_LINES_DRAFT_ALL based on the list of lines to change
3202: -- in p_line_id_list;
3203: FORALL i IN 1..p_line_id_list.COUNT
3204: UPDATE po_lines_draft_all
3205: SET change_accepted_flag = p_change_accepted_value

Line 3204: UPDATE po_lines_draft_all

3200:
3201: -- Update records in PO_LINES_DRAFT_ALL based on the list of lines to change
3202: -- in p_line_id_list;
3203: FORALL i IN 1..p_line_id_list.COUNT
3204: UPDATE po_lines_draft_all
3205: SET change_accepted_flag = p_change_accepted_value
3206: WHERE draft_id = p_draft_id
3207: AND po_line_id = p_line_id_list(i);
3208:

Line 3355: FROM po_lines_draft_all pld

3351: SELECT l_key,
3352: p_reject_line_id_list(i),
3353: pld.line_num,
3354: pld.delete_flag
3355: FROM po_lines_draft_all pld
3356: WHERE pld.draft_id = p_draft_id
3357: AND pld.po_line_id = p_reject_line_id_list(i);
3358:
3359: d_position := 20;

Line 3373: FROM po_lines_draft_all PLD

3369: WHERE PSG.key = l_key
3370: AND PSG.char2 = 'Y' -- delete_flag
3371: AND EXISTS
3372: (SELECT NULL
3373: FROM po_lines_draft_all PLD
3374: WHERE PLD.draft_id = p_draft_id
3375: AND NVL(PLD.delete_flag, 'N') <> 'Y'
3376: AND PLD.line_num = PSG.num2 -- line_num
3377: AND NOT EXISTS