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 1553: po_lines_draft_all PLD,

1549: l_new_price_tbl,
1550: l_old_price_tbl,
1551: l_new_line_flag_tbl
1552: FROM po_headers_all PH,
1553: po_lines_draft_all PLD,
1554: po_lines_all PL
1555: WHERE PLD.draft_id = p_draft_id
1556: AND NVL(PLD.delete_flag, 'N') = 'N'
1557: AND PLD.change_accepted_flag IS NULL

Line 1745: UPDATE po_lines_draft_all PLD

1741: PO_LOG.proc_begin (d_module);
1742: END IF;
1743:
1744: -- Line Level
1745: UPDATE po_lines_draft_all PLD
1746: SET PLD.change_accepted_flag = 'Y'
1747: WHERE PLD.draft_id = p_draft_id
1748: AND PLD.change_accepted_flag IS NULL
1749: AND PLD.delete_flag = 'Y'

Line 1864: UPDATE po_lines_draft_all PLD

1860: PO_LOG.proc_begin (d_module);
1861: END IF;
1862:
1863: -- Line Level Attributes
1864: UPDATE po_lines_draft_all PLD
1865: SET PLD.change_accepted_flag = 'Y'
1866: WHERE PLD.draft_id = p_draft_id
1867: AND PLD.change_accepted_flag IS NULL
1868: AND NVL(PLD.delete_flag, 'N') <> 'Y'

Line 3020: FROM po_lines_draft_all

3016: INTO l_has_record_to_accept
3017: FROM DUAL
3018: WHERE EXISTS
3019: ( SELECT 1
3020: FROM po_lines_draft_all
3021: WHERE draft_id = p_draft_id
3022: AND change_accepted_flag IS NULL)
3023: OR EXISTS
3024: ( SELECT 1

Line 3109: FROM po_lines_draft_all PLDA

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

Line 3121: FROM po_lines_draft_all PLDA

3117: WHERE PLVD.draft_id = p_draft_id
3118: AND NVL(PLVD.change_accepted_flag, 'N') <> 'Y'
3119: AND NOT EXISTS
3120: ( SELECT NULL
3121: FROM po_lines_draft_all PLDA
3122: WHERE PLDA.po_line_id = PLVD.po_line_id
3123: AND PLDA.draft_id = PLVD.draft_id );
3124:
3125: d_position := 20;

Line 3133: FROM po_lines_draft_all PLDA

3129: WHERE PLVTD.draft_id = p_draft_id
3130: AND NVL(PLVTD.change_accepted_flag, 'N') <> 'Y'
3131: AND NOT EXISTS
3132: ( SELECT NULL
3133: FROM po_lines_draft_all PLDA
3134: WHERE PLDA.po_line_id = PLVTD.po_line_id
3135: AND PLDA.draft_id = PLVTD.draft_id );
3136:
3137: d_position := 30;

Line 3146: FROM po_lines_draft_all PLDA

3142: AND NVL(PPDD.change_accepted_flag, 'N') <> 'Y'
3143: AND (( PPDD.entity_type = 'BLANKET LINE'
3144: AND NOT EXISTS
3145: ( SELECT NULL
3146: FROM po_lines_draft_all PLDA
3147: WHERE PLDA.po_line_id = PPDD.entity_id
3148: AND PLDA.draft_id = PPDD.draft_id
3149: )
3150: )

Line 3156: po_lines_draft_all PLDA

3152: ( PPDD.entity_type = 'PRICE BREAK'
3153: AND NOT EXISTS
3154: ( SELECT NULL
3155: FROM po_line_locations_draft_all PLLDA,
3156: po_lines_draft_all PLDA
3157: WHERE PLLDA.line_location_id = PPDD.entity_id
3158: AND PLLDA.draft_id = PPDD.draft_id
3159: AND PLDA.po_line_id = PLLDA.po_line_id
3160: AND PLDA.draft_id = PLLDA.draft_id )

Line 3164: po_lines_draft_all PLDA

3160: AND PLDA.draft_id = PLLDA.draft_id )
3161: AND NOT EXISTS
3162: ( SELECT NULL
3163: FROM po_line_locations_all PLLA,
3164: po_lines_draft_all PLDA
3165: WHERE PLLA.line_location_id = PPDD.entity_id
3166: AND PLDA.po_line_id = PLLA.po_line_id
3167: AND PLDA.draft_id = PPDD.draft_id)));
3168:

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

3223: END IF;
3224:
3225: x_return_status := FND_API.g_RET_STS_SUCCESS;
3226:
3227: -- Update records in PO_LINES_DRAFT_ALL based on the list of lines to change
3228: -- in p_line_id_list;
3229: FORALL i IN 1..p_line_id_list.COUNT
3230: UPDATE po_lines_draft_all
3231: SET change_accepted_flag = p_change_accepted_value

Line 3230: UPDATE po_lines_draft_all

3226:
3227: -- Update records in PO_LINES_DRAFT_ALL based on the list of lines to change
3228: -- in p_line_id_list;
3229: FORALL i IN 1..p_line_id_list.COUNT
3230: UPDATE po_lines_draft_all
3231: SET change_accepted_flag = p_change_accepted_value
3232: WHERE draft_id = p_draft_id
3233: AND po_line_id = p_line_id_list(i);
3234:

Line 3381: FROM po_lines_draft_all pld

3377: SELECT l_key,
3378: p_reject_line_id_list(i),
3379: pld.line_num,
3380: pld.delete_flag
3381: FROM po_lines_draft_all pld
3382: WHERE pld.draft_id = p_draft_id
3383: AND pld.po_line_id = p_reject_line_id_list(i);
3384:
3385: d_position := 20;

Line 3399: FROM po_lines_draft_all PLD

3395: WHERE PSG.key = l_key
3396: AND PSG.char2 = 'Y' -- delete_flag
3397: AND EXISTS
3398: (SELECT NULL
3399: FROM po_lines_draft_all PLD
3400: WHERE PLD.draft_id = p_draft_id
3401: AND NVL(PLD.delete_flag, 'N') <> 'Y'
3402: AND PLD.line_num = PSG.num2 -- line_num
3403: AND NOT EXISTS

Line 3545: FROM po_lines_draft_all

3541: SELECT 'Y'
3542: INTO l_any_line_accepted
3543: FROM dual
3544: WHERE EXISTS (SELECT 1
3545: FROM po_lines_draft_all
3546: WHERE draft_id = l_draft_id
3547: AND nvl(change_accepted_flag,'Y') = 'Y')
3548: OR EXISTS (SELECT 1
3549: FROM po_line_locations_draft_all