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_DOCUMENT_CHECKS_PVT dependencies on PO_DISTRIBUTIONS

Line 3157: -- LCM ER start. If all the submission checks have been passed successfully then update the lcm_flag of po_line_locations_all and po_distributions_all.

3153:
3154: l_progress := '027';
3155: x_return_status := FND_API.G_RET_STS_SUCCESS;
3156:
3157: -- LCM ER start. If all the submission checks have been passed successfully then update the lcm_flag of po_line_locations_all and po_distributions_all.
3158: IF p_document_type in ('PO','RELEASE') THEN
3159:
3160: FOR ship_rec in (select line_location_id from po_line_locations_gt)
3161:

Line 4099: --Removed update statement to update rate in po_distributions

4095: BEGIN
4096:
4097: l_progress := '000';
4098: -- BUG 2687600 mbhargav
4099: --Removed update statement to update rate in po_distributions
4100:
4101: l_progress := '001';
4102: IF g_debug_stmt THEN
4103: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 4533: PO_DISTRIBUTIONS_GT POD --

4529: , l_ship_amt_tbl --
4530: , l_dist_qty_tbl --
4531: , l_dist_amt_tbl --
4532: FROM
4533: PO_DISTRIBUTIONS_GT POD --
4534: , PO_LINE_LOCATIONS_GT PLL
4535: WHERE
4536: PLL.line_location_id = POD.line_location_id
4537: AND PLL.po_release_id = p_document_id

Line 4543: FROM PO_DISTRIBUTIONS_GT POD2

4539: AND nvl(PLL.closed_code,'OPEN') <> 'FINALLY CLOSED'
4540: AND ( --
4541: ( ( PLL.quantity IS NOT NULL )
4542: AND ( PLL.quantity <> ( SELECT sum(POD2.quantity_ordered)
4543: FROM PO_DISTRIBUTIONS_GT POD2
4544: WHERE POD2.line_location_id = PLL.line_location_id ) ) )
4545: OR ( ( PLL.amount IS NOT NULL )
4546: AND ( PLL.amount <> ( SELECT sum(POD2.amount_ordered)
4547: FROM PO_DISTRIBUTIONS_GT POD2

Line 4547: FROM PO_DISTRIBUTIONS_GT POD2

4543: FROM PO_DISTRIBUTIONS_GT POD2
4544: WHERE POD2.line_location_id = PLL.line_location_id ) ) )
4545: OR ( ( PLL.amount IS NOT NULL )
4546: AND ( PLL.amount <> ( SELECT sum(POD2.amount_ordered)
4547: FROM PO_DISTRIBUTIONS_GT POD2
4548: WHERE POD2.line_location_id = PLL.line_location_id ) ) )
4549: )
4550: GROUP BY
4551: PLL.shipment_num

Line 4650: FROM PO_DISTRIBUTIONS_GT POD --

4646: AND nvl(PLL.cancel_flag,'N') = 'N'
4647: AND nvl(PLL.closed_code,'OPEN') <> 'FINALLY CLOSED'
4648: AND NOT EXISTS
4649: (SELECT 'Distribution Exists'
4650: FROM PO_DISTRIBUTIONS_GT POD --
4651: WHERE POD.line_location_id = PLL.line_location_id);
4652:
4653:
4654: --Increment the p_sequence with number of errors reported in last query

Line 4697: FROM PO_DISTRIBUTIONS_GT POD, --

4693: substr(g_shipmsg||g_delim||POLL.shipment_num||g_delim
4694: ||g_distmsg||g_delim||POD.distribution_num||g_delim
4695: ||l_textline,1,240),
4696: 'PO_SUB_REL_RATE_NULL'
4697: FROM PO_DISTRIBUTIONS_GT POD, --
4698: PO_LINE_LOCATIONS_GT POLL,PO_LINES POL,
4699: PO_RELEASES_GT POR,PO_HEADERS_GT POH,GL_SETS_OF_BOOKS SOB,
4700: FINANCIALS_SYSTEM_PARAMETERS FSP
4701: WHERE POLL.po_release_id = POR.po_release_id

Line 5806: PO_DISTRIBUTIONS_GT POD

5802: POD.distribution_num||g_delim||l_textline, 1,240),
5803: 'PO_SUB_REL_DIST_DEST_TYPE_NE_I'
5804: FROM PO_RELEASES_GT POR,
5805: PO_LINE_LOCATIONS_GT PLL,
5806: PO_DISTRIBUTIONS_GT POD
5807: WHERE POR.po_release_id = POD.po_release_id
5808: AND POD.line_location_id = PLL.line_location_id
5809: AND POR.po_release_id = p_document_id
5810: AND Nvl(POD.LCM_FLAG,'N') = 'Y'

Line 6006: PO_DISTRIBUTIONS_GT POD

6002: nvl( POLL.line_location_id,0) line_loc_id
6003: FROM PO_LINE_LOCATIONS_GT POLL,
6004: PO_LINE_TYPES_B PLT, -- bug3413891
6005: PO_LINES_GT POL,
6006: PO_DISTRIBUTIONS_GT POD
6007: WHERE POLL.po_line_id = POL.po_line_id
6008: AND POLL.line_location_id = POD.line_location_id
6009: AND POLL.po_header_id = p_document_id
6010: AND POL.line_type_id = PLT.line_type_id

Line 6041: PO_DISTRIBUTIONS_GT POD

6037: nvl(POL.item_id,-1) item_id,
6038: POLL.line_location_id line_loc_id
6039: FROM PO_LINE_LOCATIONS_GT POLL,
6040: PO_LINES_GT POL,
6041: PO_DISTRIBUTIONS_GT POD
6042: WHERE POL.po_header_id = p_document_id
6043: AND POD.line_location_id = POLL.line_location_id
6044: AND POLL.line_location_id =
6045: (SELECT min(POLL2.line_location_id)

Line 6091: PO_DISTRIBUTIONS_GT POD --

6087: nvl( POLL.line_location_id,0) line_loc_id
6088: FROM PO_LINE_LOCATIONS_GT POLL,
6089: PO_LINE_TYPES_B PLT, -- bug3413891
6090: PO_LINES POL,
6091: PO_DISTRIBUTIONS_GT POD --
6092: WHERE POLL.po_line_id = POL.po_line_id
6093: AND POLL.line_location_id = POD.line_location_id
6094: AND POLL.po_release_id = p_document_id
6095: AND POL.line_type_id = PLT.line_type_id

Line 6147: PO_DISTRIBUTIONS PD,

6143: min(PRL.org_id) --
6144: FROM PO_REQUISITION_LINES_ALL PRL, --
6145: PO_LINE_LOCATIONS_GT POLL,
6146: PO_LINES POL,
6147: PO_DISTRIBUTIONS PD,
6148: PO_REQ_DISTRIBUTIONS_ALL PRD --
6149: WHERE POLL.line_location_id = p_line_location_id
6150: AND POLL.po_line_id = POL.po_line_id
6151: AND PRL.unit_price >= 0

Line 6169: PO_DISTRIBUTIONS PD,

6165: min(PRL.org_id) --
6166: FROM PO_REQUISITION_LINES_ALL PRL, --
6167: PO_LINE_LOCATIONS_GT POLL,
6168: PO_LINES POL,
6169: PO_DISTRIBUTIONS PD,
6170: PO_REQ_DISTRIBUTIONS_ALL PRD --
6171: WHERE POLL.line_location_id = p_line_location_id
6172: AND POLL.po_line_id = POL.po_line_id
6173: AND PRL.unit_price >= 0

Line 8193: * Modifies: Updates PO_DISTRIBUTIONS table with RATE information.

8189: * p_check_asl: Determines whether to perform ASL checks...
8190: * PO_SUB_ITEM_NOT_APPROVED, PO_SUB_ITEM_ASL_DEBARRED
8191: * IN OUT PARAMETERS
8192: * p_sequence: Sequence number of last reported error
8193: * Modifies: Updates PO_DISTRIBUTIONS table with RATE information.
8194: * Inserts error msgs in online_report_text_gt table, uses
8195: * global_temp tables for processing
8196: * Effects: This procedure runs the document submission checks for POs
8197: * Returns:

Line 8257: --Removed Update statement to update rate in po_distributions

8253: BEGIN
8254:
8255: l_progress := '000';
8256: -- BUG 2687600 mbhargav
8257: --Removed Update statement to update rate in po_distributions
8258:
8259: l_progress := '001';
8260: IF g_debug_stmt THEN
8261: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 8448: FROM PO_DISTRIBUTIONS_GT POD

8444: PLL.shipment_type in ('STANDARD', 'PLANNED', 'PREPAYMENT') --
8445: AND Nvl(POL.CLM_OPTION_INDICATOR, 'B') <> 'O'
8446: AND Nvl(POL.CLM_INFO_FLAG,'N')= 'N'
8447: AND NOT EXISTS (SELECT 'Distribution Exists'
8448: FROM PO_DISTRIBUTIONS_GT POD
8449: WHERE POD.line_location_id = PLL.line_location_id);
8450:
8451: --Increment the p_sequence with number of errors reported in last query
8452: p_sequence := p_sequence + SQL%ROWCOUNT;

Line 8522: FROM PO_DISTRIBUTIONS_GT POD,PO_LINE_LOCATIONS_GT PLL,PO_LINES_GT POL,

8518: ||g_shipmsg||g_delim||PLL.shipment_num||g_delim
8519: ||g_distmsg||g_delim||POD.distribution_num||g_delim
8520: ||l_textline,1,240),
8521: 'PO_SUB_DIST_RATE_NULL'
8522: FROM PO_DISTRIBUTIONS_GT POD,PO_LINE_LOCATIONS_GT PLL,PO_LINES_GT POL,
8523: PO_HEADERS_GT POH,GL_SETS_OF_BOOKS SOB,FINANCIALS_SYSTEM_PARAMETERS FSP
8524: WHERE POD.po_header_id = POH.po_header_id
8525: AND POD.line_location_id = PLL.line_location_id
8526: AND PLL.po_line_id = POL.po_line_id

Line 8581: FROM PO_DISTRIBUTIONS_GT POD,PO_LINE_LOCATIONS_GT PLL,PO_LINES_GT POL,

8577: ||g_shipmsg||g_delim||PLL.shipment_num||g_delim
8578: ||g_distmsg||g_delim||POD.distribution_num||g_delim
8579: ||l_textline,1,240),
8580: 'PO_SUB_DIST_RATE_NOT_NULL'
8581: FROM PO_DISTRIBUTIONS_GT POD,PO_LINE_LOCATIONS_GT PLL,PO_LINES_GT POL,
8582: PO_HEADERS_GT POH,GL_SETS_OF_BOOKS SOB,FINANCIALS_SYSTEM_PARAMETERS FSP
8583: WHERE POD.po_header_id = POH.po_header_id
8584: AND POD.line_location_id = PLL.line_location_id
8585: AND PLL.po_line_id = POL.po_line_id

Line 9817: FROM po_distributions_gt pod,

9813: 'LINE_NUM',pol.line_num,
9814: 'SHIP_NUM',pos.shipment_num,
9815: 'DIST_NUM',pod.distribution_num),
9816: 'PO_INVALID_OKE_CONTRACT_LNE_ID'
9817: FROM po_distributions_gt pod,
9818: po_line_locations_gt pos,
9819: po_lines_gt pol
9820: WHERE pod.po_line_id = pol.po_line_id
9821: AND pod.line_location_id = pos.line_location_id

Line 9866: FROM po_distributions_gt pod,

9862: 'LINE_NUM',pol.line_num,
9863: 'SHIP_NUM',pos.shipment_num,
9864: 'DIST_NUM',pod.distribution_num),
9865: 'PO_INVALID_OKE_CONTRACT_DLV_ID'
9866: FROM po_distributions_gt pod,
9867: po_line_locations_gt pos,
9868: po_lines_gt pol
9869: WHERE pod.po_line_id = pol.po_line_id
9870: AND pod.line_location_id = pos.line_location_id

Line 10026: PO_DISTRIBUTIONS_GT POD

10022: 'PO_SUB_PO_DIST_DEST_TYPE_NE_IN'
10023: FROM PO_HEADERS_GT POH,
10024: PO_LINES_GT POL,
10025: PO_LINE_LOCATIONS_GT PLL,
10026: PO_DISTRIBUTIONS_GT POD
10027: WHERE POH.po_header_id = POD.po_header_id
10028: AND POD.line_location_id = PLL.line_location_id
10029: AND PLL.po_line_id = POL.po_line_id
10030: AND POH.po_header_id = p_document_id

Line 10086: PO_DISTRIBUTIONS_GT POD

10082: p_sequence + ROWNUM,
10083: substr(l_textline,1,240),
10084: 'PO_PDOI_INVALID_FUND_VAL_ENC'
10085: FROM
10086: PO_DISTRIBUTIONS_GT POD
10087: , PO_LINE_LOCATIONS_GT POLL
10088: , PO_LINES_GT POL
10089: WHERE POLL.line_location_id(+) = POD.line_location_id --JOIN
10090: AND POL.po_line_id(+) = POD.po_line_id --JOIN

Line 10156: FROM PO_DISTRIBUTIONS_GT POD1,

10152:
10153: SELECT POL.line_num
10154: BULK COLLECT INTO
10155: l_line_num
10156: FROM PO_DISTRIBUTIONS_GT POD1,
10157: PO_DISTRIBUTIONS_GT POD2,
10158: PO_LINES_GT POL
10159: WHERE POD1.po_line_id = POL.po_line_id
10160: AND POD2.po_line_id = POL.po_line_id

Line 10157: PO_DISTRIBUTIONS_GT POD2,

10153: SELECT POL.line_num
10154: BULK COLLECT INTO
10155: l_line_num
10156: FROM PO_DISTRIBUTIONS_GT POD1,
10157: PO_DISTRIBUTIONS_GT POD2,
10158: PO_LINES_GT POL
10159: WHERE POD1.po_line_id = POL.po_line_id
10160: AND POD2.po_line_id = POL.po_line_id
10161: AND POL.po_header_id = p_document_id

Line 10273: FROM PO_DISTRIBUTIONS_GT POD

10269: FROM PO_CLMREQ_DIST_DETAILS_V PRD
10270: WHERE PRD.funds_remaining < 0
10271: AND exists(
10272: SELECT NULL
10273: FROM PO_DISTRIBUTIONS_GT POD
10274: WHERE POD.po_header_id = p_document_id
10275: AND NVL(POD.DISTRIBUTION_TYPE, 'STANDARD') = 'STANDARD'
10276: AND POD.req_distribution_id = PRD.distribution_id);
10277:

Line 11613: FROM PO_DISTRIBUTIONS_GT

11609: SELECT count('Y')
11610: INTO l_count_expense_dist
11611: FROM DUAL
11612: WHERE EXISTS(SELECT 'Y'
11613: FROM PO_DISTRIBUTIONS_GT
11614: WHERE LINE_LOCATION_ID = l_line_location_id(i)
11615: AND DESTINATION_TYPE_CODE = 'EXPENSE');
11616:
11617: IF(l_count_expense_dist <= 0)

Line 13487: DELETE FROM po_distributions_gt;

13483:
13484: DELETE FROM po_headers_gt;
13485: DELETE FROM po_lines_gt;
13486: DELETE FROM po_line_locations_gt;
13487: DELETE FROM po_distributions_gt;
13488: DELETE FROM po_releases_gt;
13489: DELETE FROM po_req_headers_gt;
13490: DELETE FROM po_req_lines_gt;
13491: DELETE FROM po_req_distributions_gt;

Line 14144: UPDATE po_distributions_gt

14140: -- in values or if NULL then with existing values in the table
14141: -- SQL Why: Need to apply requested line level changes to global temp table
14142: -- SQL Join: po_line_id
14143: FORALL i IN 1..p_requested_changes.distribution_changes.po_distribution_id.COUNT
14144: UPDATE po_distributions_gt
14145: SET quantity_ordered = nvl(p_requested_changes.distribution_changes.quantity_ordered(i),
14146: quantity_ordered),
14147: --
14148: -- Added amount_ordered as a changeable field:

Line 17346: PO_DISTRIBUTIONS_GT POD

17342: , NULL , 'PO_SUB_DIST_BILL_GT_ORD_AMT'
17343: , 'PO_SUB_DIST_BILL_GT_ORD_QTY'
17344: )
17345: FROM
17346: PO_DISTRIBUTIONS_GT POD
17347: , PO_LINE_LOCATIONS_GT POLL
17348: , PO_LINES_ALL POL -- For releases, PO_LINES_GT table isn't populated.
17349: WHERE POD.line_location_id = POLL.line_location_id
17350: AND POL.po_line_id = POLL.po_line_id

Line 17433: PO_DISTRIBUTIONS_GT POD

17429: , NULL , 'PO_SUB_DIST_DLVR_GT_ORD_AMT'
17430: , 'PO_SUB_DIST_DLVR_GT_ORD_QTY'
17431: )
17432: FROM
17433: PO_DISTRIBUTIONS_GT POD
17434: , PO_LINE_LOCATIONS_GT POLL
17435: , PO_LINES_ALL POL -- For releases, PO_LINES_GT table isn't populated.
17436: WHERE POD.line_location_id = POLL.line_location_id
17437: AND POL.po_line_id = POLL.po_line_id

Line 18021: INSERT INTO PO_DISTRIBUTIONS_GT

18017: End;
18018: END IF;
18019:
18020: FORALL i IN 1 .. l_dist_id_tbl.COUNT
18021: INSERT INTO PO_DISTRIBUTIONS_GT
18022: (
18023: po_distribution_id ,
18024: last_update_date ,
18025: last_updated_by ,

Line 18226: FROM PO_DISTRIBUTIONS_MERGE_V POD

18222: , pod.funded_value ,
18223: pod.acrn,
18224: pod.clm_payment_sequence_num
18225:
18226: FROM PO_DISTRIBUTIONS_MERGE_V POD
18227: WHERE POD.po_distribution_id = l_dist_id_tbl(i)
18228: and pod.draft_id = p_draft_id
18229: /* -- CLM Aprvl
18230: FROM PO_DISTRIBUTIONS_ALL POD

Line 18230: FROM PO_DISTRIBUTIONS_ALL POD

18226: FROM PO_DISTRIBUTIONS_MERGE_V POD
18227: WHERE POD.po_distribution_id = l_dist_id_tbl(i)
18228: and pod.draft_id = p_draft_id
18229: /* -- CLM Aprvl
18230: FROM PO_DISTRIBUTIONS_ALL POD
18231: WHERE POD.po_distribution_id = l_dist_id_tbl(i)
18232: */-- CLM Aprvl
18233: -- need to change the entities which should be validated. Only records in the draft tables should be validated.
18234: AND (l_draft_type <> 'PAR'

Line 18417: PO_DISTRIBUTIONS_GT POD

18413: , l_line_num_tbl
18414: , l_shipment_num_tbl
18415: , l_distribution_num_tbl
18416: FROM
18417: PO_DISTRIBUTIONS_GT POD
18418: , PO_LINE_LOCATIONS_GT POLL
18419: , PO_LINES_ALL POL -- For Releases, PO_LINES_GT doesn't get populated.
18420: , PO_HEADERS_GT POH
18421: WHERE POLL.line_location_id(+) = POD.line_location_id --JOIN

Line 20008: FROM po_lines_gt pol, po_line_locations_gt poll, po_distributions_gt pod

20004: , 'QTY1', round(sum(NVL(pod.quantity_delivered, 0)),5) /* Bug:13427569 rounded to 5 digits */
20005: )
20006: ), 1, 240)
20007: , 'PO_CAN_POLL_REC_NOT_DEL'
20008: FROM po_lines_gt pol, po_line_locations_gt poll, po_distributions_gt pod
20009: WHERE pod.line_location_id = poll.line_location_id
20010: AND pol.po_line_id = poll.po_line_id
20011: AND pol.order_type_lookup_code NOT IN ('RATE', 'FIXED PRICE')
20012: AND NVL(poll.cancel_flag, 'N') = 'N'

Line 20017: FROM po_distributions_gt pod2

20013: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
20014: AND round(NVL(poll.quantity_received, 0),5) > /* Bug:13427569 rounded to 5 digits */
20015: (
20016: SELECT round(sum(NVL(pod2.quantity_delivered, 0)),5) /* Bug:13427569 rounded to 5 digits */
20017: FROM po_distributions_gt pod2
20018: WHERE pod2.line_location_id = poll.line_location_id
20019: )
20020: GROUP BY pol.line_num
20021: , poll.shipment_num

Line 20131: FROM po_lines_gt pol, po_line_locations_gt poll, po_distributions_gt pod

20127: , 'QTY1', sum(NVL(pod.amount_delivered, 0))
20128: )
20129: ), 1, 240)
20130: , 'PO_CAN_POLL_AMT_REC_NOT_DEL'
20131: FROM po_lines_gt pol, po_line_locations_gt poll, po_distributions_gt pod
20132: WHERE pod.line_location_id = poll.line_location_id
20133: AND pol.po_line_id = poll.po_line_id
20134: AND pol.order_type_lookup_code IN ('RATE', 'FIXED PRICE')
20135: AND NVL(poll.cancel_flag, 'N') = 'N'

Line 20140: FROM po_distributions_gt pod2

20136: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
20137: AND NVL(poll.amount_received, 0) >
20138: (
20139: SELECT sum(NVL(pod2.amount_delivered, 0))
20140: FROM po_distributions_gt pod2
20141: WHERE pod2.line_location_id = poll.line_location_id
20142: )
20143: GROUP BY pol.line_num
20144: , poll.shipment_num

Line 20267: , po_distributions_gt pod, gl_code_combinations gcc

20263: || poll.shipment_num || g_delim || g_distmsg || g_delim || l_textline
20264: ), 1, 240)
20265: , 'PO_CAN_POLL_INVALID_ACCT_FLEX'
20266: FROM po_lines_gt pol, po_line_locations_gt poll
20267: , po_distributions_gt pod, gl_code_combinations gcc
20268: WHERE pod.line_location_id = poll.line_location_id
20269: AND pol.po_line_id = poll.po_line_id
20270: AND poll.shipment_type IN ('STANDARD', 'PLANNED', 'PREPAYMENT') --
20271: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 21091: FROM PO_DISTRIBUTIONS_GT POD,PO_LINE_LOCATIONS_GT PLL, PO_LINES_GT POL

21087: , l_lineloc_amt_tbl
21088: , l_dist_qty_tbl
21089: , l_dist_amt_tbl
21090: , l_line_id_tbl -- bug 16474947
21091: FROM PO_DISTRIBUTIONS_GT POD,PO_LINE_LOCATIONS_GT PLL, PO_LINES_GT POL
21092: WHERE PLL.po_line_id = POL.po_line_id
21093: AND POD.line_location_id = PLL.line_location_id
21094: AND PLL.po_header_id = p_document_id
21095: AND nvl(PLL.cancel_flag,'N') = 'N'

Line 21575: FROM po_distributions_gt pod

21571: , distribution_num
21572: , p_sequence + ROWNUM
21573: , substr(l_textline, 1, 240)
21574: , l_message_name
21575: FROM po_distributions_gt pod
21576: WHERE pod.po_distribution_id=p_doc_level_id
21577: AND chk_unv_invoices(l_invoice_type, pod.po_header_id, pod.po_release_id, NULL,NULL, pod.po_distribution_id, p_origin_doc_id, l_calling_sequence) = 1;
21578: END IF; --
21579:

Line 21652: FROM po_distributions_gt

21648: WHERE line_location_id=p_doc_level_id;
21649: ELSIF p_document_level = g_document_level_DISTRIBUTION THEN
21650: SELECT po_header_id
21651: INTO l_document_id
21652: FROM po_distributions_gt
21653: WHERE po_distribution_id=p_doc_level_id;
21654: END IF;
21655: IF p_document_type <> g_document_type_RELEASE THEN
21656: l_is_complex_po := PO_COMPLEX_WORK_PVT.is_complex_work_po(l_document_id);

Line 21823: UPDATE po_distributions_gt

21819: SET lcm_flag = 'Y'
21820: WHERE line_location_id = p_line_location_id
21821: and lcm_flag is null;
21822:
21823: UPDATE po_distributions_gt
21824: SET lcm_flag = 'Y'
21825: WHERE line_location_id = p_line_location_id
21826: and lcm_flag is null;
21827:

Line 21835: UPDATE po_distributions_all

21831: UPDATE po_line_locations_all
21832: SET lcm_flag = 'Y'
21833: WHERE line_location_id = p_line_location_id;
21834:
21835: UPDATE po_distributions_all
21836: SET lcm_flag = 'Y'
21837: WHERE line_location_id = p_line_location_id;
21838: END IF;
21839:

Line 21847: UPDATE po_distributions_all

21843: SET lcm_flag = null
21844: WHERE line_location_id = p_line_location_id
21845: AND lcm_flag = 'Y';
21846:
21847: UPDATE po_distributions_all
21848: SET lcm_flag = null
21849: WHERE line_location_id = p_line_location_id
21850: AND lcm_flag = 'Y';
21851:

Line 22801: PO_DISTRIBUTIONS_GT POD,

22797: SUBSTR(g_linemsg||g_delim||POL.line_num_display||g_delim
22798: ||g_shipmsg||g_delim||PLL.shipment_num||g_delim||g_distmsg||g_delim||POD.DISTRIBUTION_NUM||g_delim||L_TEXTLINE,1,240),
22799: 'PO_CHARGE_NOT_NULL'
22800: FROM
22801: PO_DISTRIBUTIONS_GT POD,
22802: PO_LINE_LOCATIONS_GT PLL,
22803: PO_LINES_GT POL
22804: WHERE POD.CODE_COMBINATION_ID IS NULL
22805: AND POD.PO_HEADER_ID = P_DOCUMENT_ID

Line 22850: PO_DISTRIBUTIONS_GT POD,

22846: SUBSTR(g_linemsg||g_delim||POL.line_num_display||g_delim
22847: ||g_shipmsg||g_delim||PLL.shipment_num||g_delim||g_distmsg||g_delim||POD.DISTRIBUTION_NUM||g_delim||L_TEXTLINE,1,240),
22848: 'PO_ALL_NO_BUDGET_FLEX'
22849: FROM
22850: PO_DISTRIBUTIONS_GT POD,
22851: PO_LINE_LOCATIONS_GT PLL,
22852: PO_LINES_GT POL
22853: WHERE POD.BUDGET_ACCOUNT_ID IS NULL
22854: AND POD.PO_HEADER_ID = P_DOCUMENT_ID

Line 23112: FROM po_distributions_merge_v pda,

23108: (SELECT pda.po_distribution_id,
23109: glcc.concatenated_segments charge_acc,
23110: pda.clm_misc_loa ,
23111: pda.acrn
23112: FROM po_distributions_merge_v pda,
23113: gl_code_combinations_kfv glcc
23114: WHERE pda.po_header_id = P_DOCUMENT_ID
23115: and pda.draft_id = P_DRAFT_ID
23116: AND pda.code_combination_id = glcc.code_combination_id

Line 23495: po_distributions_gt pd,

23491: pll.shipment_num,
23492: 'PO_CLOSE_WIP_JOB'
23493: FROM po_headers_gt ph,
23494: po_line_locations_gt pll,
23495: po_distributions_gt pd,
23496: po_releases_gt pr
23497: WHERE 1=1
23498: AND ph.po_header_id = pll.po_header_id
23499: AND pll.line_location_id = pd.line_location_id

Line 23555: po_distributions_gt pd

23551: 'PO_CLOSE_WIP_JOB'
23552: FROM po_headers_gt ph,
23553: po_lines_gt pl,
23554: po_line_locations_gt pll,
23555: po_distributions_gt pd
23556: WHERE 1=1
23557: AND ph.po_header_id = pl.po_header_id
23558: AND pl.po_line_id=pll.po_line_id
23559: AND ph.type_lookup_code = 'STANDARD'

Line 23902: PO_DISTRIBUTIONS_GT POD,

23898: POLL.shipment_num, 1, 240
23899: ),
23900: Nvl2( PoD.code_combination_id, 'PO_RI_INVALID_CHARGE_ACC_ID', 'PO_CHARGE_NOT_NULL' )
23901: FROM
23902: PO_DISTRIBUTIONS_GT POD,
23903: gl_sets_of_books sob,
23904: PO_LINE_LOCATIONS_GT POLL
23905: WHERE
23906: POD.PO_RELEASE_ID = P_DOCUMENT_ID

Line 23962: PO_DISTRIBUTIONS_GT POD,

23958: POLL.shipment_num, 1, 240
23959: ),
23960: Nvl2( PoD.budget_account_id, 'PO_RI_INVALID_BUDGET_ACC_ID', 'PO_BUDGET_NOT_NULL' )
23961: FROM
23962: PO_DISTRIBUTIONS_GT POD,
23963: gl_sets_of_books sob,
23964: PO_LINE_LOCATIONS_GT POLL
23965: WHERE
23966: POD.PO_RELEASE_ID = P_DOCUMENT_ID

Line 24022: PO_DISTRIBUTIONS_GT POD,

24018: POLL.shipment_num, 1, 240
24019: ),
24020: Nvl2( PoD.accrual_account_id, 'PO_RI_INVALID_ACCRUAL_ACC_ID', 'PO_ACCRUAL_NOT_NULL' )
24021: FROM
24022: PO_DISTRIBUTIONS_GT POD,
24023: gl_sets_of_books sob,
24024: PO_LINE_LOCATIONS_GT POLL
24025: WHERE
24026: POD.PO_RELEASE_ID = P_DOCUMENT_ID

Line 24080: PO_DISTRIBUTIONS_GT POD,

24076: POLL.shipment_num, 1, 240
24077: ),
24078: Nvl2( PoD.variance_account_id, 'PO_RI_INVALID_VARIANCE_ACC_ID', 'PO_VARIANCE_NOT_NULL' )
24079: FROM
24080: PO_DISTRIBUTIONS_GT POD,
24081: gl_sets_of_books sob,
24082: PO_LINE_LOCATIONS_GT POLL
24083: WHERE
24084: POD.PO_RELEASE_ID = P_DOCUMENT_ID

Line 24149: PO_DISTRIBUTIONS_GT POD,

24145: POL.line_num, 1, 240
24146: ),
24147: Nvl2( PoD.code_combination_id, 'PO_RI_INVALID_CHARGE_ACC_ID', 'PO_CHARGE_NOT_NULL' )
24148: FROM
24149: PO_DISTRIBUTIONS_GT POD,
24150: gl_sets_of_books sob,
24151: PO_LINE_LOCATIONS_GT POLL,
24152: PO_LINES_GT POL
24153: WHERE

Line 24212: PO_DISTRIBUTIONS_GT POD,

24208: POL.line_num, 1, 240
24209: ),
24210: Nvl2( PoD.budget_account_id, 'PO_RI_INVALID_BUDGET_ACC_ID', 'PO_BUDGET_NOT_NULL' )
24211: FROM
24212: PO_DISTRIBUTIONS_GT POD,
24213: gl_sets_of_books sob,
24214: PO_LINE_LOCATIONS_GT POLL,
24215: PO_LINES_GT POL
24216: WHERE

Line 24279: PO_DISTRIBUTIONS_GT POD,

24275: POL.line_num, 1, 240
24276: ),
24277: Nvl2( PoD.accrual_account_id, 'PO_RI_INVALID_ACCRUAL_ACC_ID', 'PO_ACCRUAL_NOT_NULL' )
24278: FROM
24279: PO_DISTRIBUTIONS_GT POD,
24280: gl_sets_of_books sob,
24281: PO_LINE_LOCATIONS_GT POLL,
24282: PO_LINES_GT POL
24283: WHERE

Line 24341: PO_DISTRIBUTIONS_GT POD,

24337: POL.line_num, 1, 240
24338: ),
24339: Nvl2( PoD.variance_account_id, 'PO_RI_INVALID_VARIANCE_ACC_ID', 'PO_VARIANCE_NOT_NULL' )
24340: FROM
24341: PO_DISTRIBUTIONS_GT POD,
24342: gl_sets_of_books sob,
24343: PO_LINE_LOCATIONS_GT POLL,
24344: PO_LINES_GT POL
24345: WHERE

Line 24716: po_distributions_gt POD

24712: 'E'
24713: FROM po_headers_gt POH,
24714: po_lines_gt POL,
24715: po_line_locations_gt POLL,
24716: po_distributions_gt POD
24717: WHERE POH.po_header_id = p_document_id
24718: AND POL.po_header_id = POH.po_header_id
24719: AND POLL.po_header_id = POH.po_header_id
24720: AND POLL.po_line_id = POL.po_line_id

Line 24777: FROM po_distributions_gt POD, po_distributions_gt POD2

24773: FROM po_lines_gt POL
24774: WHERE POL.po_header_id = p_document_id
24775: AND POL.clm_payment_instr_code = 'SINGLE_FUNDING'
24776: AND EXISTS ( SELECT 1
24777: FROM po_distributions_gt POD, po_distributions_gt POD2
24778: WHERE POD2.po_header_id = POL.po_header_id
24779: AND POD2.po_line_id = POL.po_line_id
24780: AND POD2.po_header_id = POD.po_header_id
24781: AND POD2.po_line_id = POD.po_line_id

Line 24827: FROM po_distributions_gt pd

24823: AND NVl(POL.cost_constraint,'Priced') NOT IN ('NSP', 'NC')
24824: AND (POL.clm_payment_instr_code is NULL
24825: AND POH.clm_payment_instr_code is NULL )
24826: AND EXISTS ( SELECT 'At least one distribution exists'
24827: FROM po_distributions_gt pd
24828: WHERE pd.po_line_id = POL.po_line_id
24829: AND pd.po_header_id = POL.po_header_id);
24830:
24831: p_sequence := p_sequence + SQL%ROWCOUNT;

Line 25115: FROM po_distributions_gt pda,

25111: AND poll.po_header_id = pll.po_header_id),
25112: pda.set_of_books_id) Min_start_date_fiscal_year,
25113: po_core_s3.Get_fiscal_year(pll.clm_period_perf_end_date,
25114: pda.set_of_books_id) end_date_fiscal_year
25115: FROM po_distributions_gt pda,
25116: po_line_locations_gt pll,
25117: (SELECT pol.po_line_id,
25118: Nvl(POL.line_num_display,POL.line_num) line_num
25119: FROM po_headers_gt pha,

Line 25823: FROM po_distributions_gt POD,

25819: POL.line_num,
25820: POL.line_num_display,
25821: POLL.shipment_num,
25822: POD.distribution_num
25823: FROM po_distributions_gt POD,
25824: po_req_distributions_all PRD,
25825: po_requisition_lines_all PRL,
25826: po_requisition_headers_all PRH,
25827: po_line_locations_gt POLL,

Line 25881: FROM po_distributions_gt POD

25877: INTO l_non_mipr_ref_exists
25878: FROM dual
25879: WHERE EXISTS(
25880: SELECT 1
25881: FROM po_distributions_gt POD
25882: WHERE POD.po_header_id = p_document_id
25883: AND req_distribution_id IS NOT NULL --PO Dist has a req reference
25884: AND NOT EXISTS(
25885: SELECT 1

Line 26321: PO_DISTRIBUTIONS_GT POD,

26317: ' and Distribution '||POD.DISTRIBUTION_NUM ||
26318: ' of Line '||POL.line_num||' , '|| L_TEXTLINE,
26319: 'PO_RI_INVALID_ACCRUE_ON_RCT'
26320: FROM
26321: PO_DISTRIBUTIONS_GT POD,
26322: PO_LINE_LOCATIONS_GT POLL,
26323: PO_LINES_GT POL,
26324: PO_HEADERS_GT POH
26325:

Line 26372: PO_DISTRIBUTIONS_GT POD,

26368: ' and Distribution '||POD.DISTRIBUTION_NUM ||
26369: ' of Line '||POL.line_num||' , '|| L_TEXTLINE,
26370: 'PO_RI_INVALID_ACCRUE_ON_RCT'
26371: FROM
26372: PO_DISTRIBUTIONS_GT POD,
26373: PO_LINE_LOCATIONS_GT POLL,
26374: PO_LINES POL,
26375: PO_RELEASES_GT POR
26376: