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_RELGEN_PKG dependencies on PO_LINE_LOCATIONS

Line 237: /Bug 7609663: Update the approved_flag in po_releses_all and po_line_locations_all /

233: -- Update Release with status INCOMPLETE
234: -- as the tax calculation has failed
235: --
236:
237: /*Bug 7609663: Update the approved_flag in po_releses_all and po_line_locations_all */
238:
239: UPDATE po_releases_all por
240: SET por.authorization_status = 'INCOMPLETE',
241: por.approved_flag = 'N'

Line 244: UPDATE po_line_locations_all plla

240: SET por.authorization_status = 'INCOMPLETE',
241: por.approved_flag = 'N'
242: WHERE por.po_release_id = x_po_release_id;
243:
244: UPDATE po_line_locations_all plla
245: SET plla.approved_flag = 'N'
246: WHERE plla.po_release_id = x_po_release_id;
247:
248: /* Bug 7609663: end */

Line 360: UPDATE po_line_locations_all plla

356: por.approved_flag = 'N',
357: por.approved_date = NULL
358: WHERE por.po_release_id = x_po_release_id;
359:
360: UPDATE po_line_locations_all plla
361: SET plla.approved_flag = 'N',
362: plla.approved_date = NULL,
363: plla.lcm_flag = NULL
364: WHERE plla.po_release_id = x_po_release_id

Line 510: /Bug 7609663: Update the approved_flag in po_releses_all and po_line_locations_all /

506: -- ECO Bug 4643026
507: -- Update Release with status INCOMPLETE
508: -- as the tax calculation has failed
509: --
510: /*Bug 7609663: Update the approved_flag in po_releses_all and po_line_locations_all */
511:
512: UPDATE po_releases_all por
513: SET por.authorization_status = 'INCOMPLETE',
514: por.approved_flag = 'N'

Line 517: UPDATE po_line_locations_all plla

513: SET por.authorization_status = 'INCOMPLETE',
514: por.approved_flag = 'N'
515: WHERE por.po_release_id = x_po_release_id;
516:
517: UPDATE po_line_locations_all plla
518: SET plla.approved_flag = 'N'
519: WHERE plla.po_release_id = x_po_release_id;
520:
521: /* Bug 7609663: end */

Line 617: UPDATE po_line_locations_all plla

613: por.approved_flag = 'N',
614: por.approved_date = NULL
615: WHERE por.po_release_id = x_po_release_id;
616:
617: UPDATE po_line_locations_all plla
618: SET plla.approved_flag = 'N',
619: plla.approved_date = NULL,
620: plla.lcm_flag = NULL
621: WHERE plla.po_release_id = x_po_release_id

Line 870: l_outsourced_assembly PO_LINE_LOCATIONS_ALL.outsourced_assembly%TYPE;

866: l_promised_date DATE := NULL;
867: l_po_promised_def_prf VARCHAR2(1) := fnd_profile.value('PO_NEED_BY_PROMISE_DEFAULTING');
868: --
869:
870: l_outsourced_assembly PO_LINE_LOCATIONS_ALL.outsourced_assembly%TYPE;
871: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --Bug 4896950
872: l_matching_basis PO_LINES_ALL.matching_basis%TYPE; --Bug 4896950
873: l_unit_meas_lookup_code PO_LINES_ALL.unit_meas_lookup_code%TYPE; --Bug 4896950
874:

Line 898: SELECT PO_LINE_LOCATIONS_S.NEXTVAL

894: END IF;
895: END IF;
896: --
897:
898: SELECT PO_LINE_LOCATIONS_S.NEXTVAL
899: INTO x_line_location_id
900: FROM SYS.DUAL;
901:
902: /* Bug 1834138. pchintal. Commented the below SQL and added new Code

Line 908: FROM PO_LINE_LOCATIONS

904: improving the performance of the create releases process.
905:
906: SELECT NVL(MAX(SHIPMENT_NUM) +1,1)
907: INTO x_shipment_num
908: FROM PO_LINE_LOCATIONS
909: WHERE PO_RELEASE_ID = x_po_release_id;
910: */
911:
912: Gship_num_prev :=Gship_num_prev+1;

Line 1118: INSERT INTO PO_LINE_LOCATIONS(

1114: );
1115: END IF;
1116: -- Bug 3570793 END
1117:
1118: INSERT INTO PO_LINE_LOCATIONS(
1119: LINE_LOCATION_ID,
1120: LAST_UPDATE_DATE,
1121: LAST_UPDATED_BY,
1122: PO_HEADER_ID,

Line 1554: PO_LINE_LOCATIONS PLL

1550: PH.Org_Id --
1551: FROM PO_REQ_DISTRIBUTIONS PRD,
1552: PO_REQUISITION_LINES PRL,
1553: PO_HEADERS PH,
1554: PO_LINE_LOCATIONS PLL
1555: WHERE PRD.REQUISITION_LINE_ID = req_line.requisition_line_id
1556: AND PRL.REQUISITION_LINE_ID = req_line.requisition_line_id
1557: AND PH.PO_HEADER_ID = req_line.blanket_po_header_id
1558: AND PLL.LINE_LOCATION_ID = x_line_location_id;

Line 1571: FROM PO_LINE_LOCATIONS POLL,

1567: --
1568:
1569: SELECT POLL.quantity
1570: INTO x_shipment_quantity
1571: FROM PO_LINE_LOCATIONS POLL,
1572: PO_REQUISITION_LINES PORL
1573: WHERE POLL.LINE_LOCATION_ID = PORL.LINE_LOCATION_ID
1574: AND PORL.REQUISITION_LINE_ID
1575: = req_line.requisition_line_id;

Line 1579: FROM PO_LINE_LOCATIONS POLL,

1575: = req_line.requisition_line_id;
1576:
1577: SELECT SUM(POD.QUANTITY_ORDERED)
1578: INTO x_dist_quantity
1579: FROM PO_LINE_LOCATIONS POLL,
1580: PO_REQUISITION_LINES PORL,
1581: PO_DISTRIBUTIONS POD
1582: WHERE POLL.LINE_LOCATION_ID = PORL.LINE_LOCATION_ID
1583: AND PORL.REQUISITION_LINE_ID

Line 1596: PO_LINE_LOCATIONS POLL,

1592: = POD.QUANTITY_ORDERED + x_qty_difference
1593: WHERE POD.PO_DISTRIBUTION_ID =
1594: (SELECT POD2.PO_DISTRIBUTION_ID
1595: FROM PO_DISTRIBUTIONS POD2,
1596: PO_LINE_LOCATIONS POLL,
1597: PO_REQUISITION_LINES PORL
1598: WHERE POD2.LINE_LOCATION_ID
1599: = POLL.LINE_LOCATION_ID
1600: AND POLL.LINE_LOCATION_ID

Line 1960: po_line_locations poll,

1956: pod.destination_organization_id,
1957: pod.destination_subinventory,
1958: 'Y'
1959: from po_distributions pod,
1960: po_line_locations poll,
1961: po_lines pol
1962: where poll.line_location_id = x_line_location_id
1963: and nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1964: and nvl(poll.closed_code, 'OPEN') <> 'CLOSED'

Line 2171: FROM PO_LINE_LOCATIONS

2167: -- Hence, added a nvl for it.
2168:
2169: SELECT nvl(SUM(QUANTITY - nvl(QUANTITY_CANCELLED, 0)), 0)
2170: INTO x_price_break_quantity
2171: FROM PO_LINE_LOCATIONS
2172: WHERE PO_LINE_ID = req_line.blanket_po_line_id
2173: AND SHIPMENT_TYPE <> 'PRICE BREAK';
2174:
2175: -- End of fix. Bug 521788, lpo, 03/26/98

Line 2209: FROM PO_LINE_LOCATIONS

2205: /* Determine the final price for the item shipment */
2206:
2207: SELECT LEAST(NVL(MIN(PRICE_OVERRIDE), x_po_line_price), x_po_line_price)
2208: INTO x_best_price
2209: FROM PO_LINE_LOCATIONS
2210: WHERE SHIPMENT_TYPE = 'PRICE BREAK'
2211: AND PO_LINE_ID = req_line.blanket_po_line_id
2212: AND QUANTITY <= x_price_break_quantity
2213: AND (SHIP_TO_LOCATION_ID = NVL(x_ship_to_location_id,

Line 2261: FROM po_line_locations poll

2257: x_check_status := FND_API.G_RET_STS_SUCCESS; -- Bug 2701147
2258:
2259: SELECT nvl(sum(poll.quantity * poll.price_override),0)
2260: INTO release_amount
2261: FROM po_line_locations poll
2262: WHERE poll.po_release_id = x_po_release_id
2263: AND poll.shipment_type = 'BLANKET';
2264:
2265: SELECT nvl(sum(poll.quantity * poll.price_override),0)

Line 2267: FROM po_line_locations poll,

2263: AND poll.shipment_type = 'BLANKET';
2264:
2265: SELECT nvl(sum(poll.quantity * poll.price_override),0)
2266: INTO total_release_amount
2267: FROM po_line_locations poll,
2268: po_releases por,
2269: po_headers poh
2270: WHERE poh.po_header_id = x_old_po_header_id
2271: AND poll.po_header_id = poh.po_header_id

Line 2502: FROM PO_LINE_LOCATIONS POLL,

2498: nvl(POL.line_num,0) line_num,
2499: nvl(POLL.quantity,0) quantity,
2500: nvl(POL.item_id,0) item_id,
2501: nvl( POLL.line_location_id,0) line_loc_id
2502: FROM PO_LINE_LOCATIONS POLL,
2503: PO_LINE_TYPES PLT,
2504: PO_LINES POL,
2505: PO_DISTRIBUTIONS POD
2506: WHERE POLL.po_line_id = POL.po_line_id

Line 2523: PO_LINE_LOCATIONS POLL,

2519: PRL.unit_meas_lookup_code,
2520: min(POL.line_num),
2521: min(POLL.shipment_num)
2522: FROM PO_REQUISITION_LINES PRL,
2523: PO_LINE_LOCATIONS POLL,
2524: PO_LINES POL
2525: WHERE PRL.line_location_id = POLL.line_location_id
2526: AND POLL.line_location_id = p_line_location_id
2527: AND PRL.unit_price >= 0

Line 2538: PO_LINE_LOCATIONS POLL,

2534: sum(PD.quantity_ordered),
2535: min(POL.line_num),
2536: min(POLL.shipment_num)
2537: FROM PO_REQUISITION_LINES PRL,
2538: PO_LINE_LOCATIONS POLL,
2539: PO_LINES POL,
2540: PO_DISTRIBUTIONS PD,
2541: PO_REQ_DISTRIBUTIONS PRD
2542: WHERE POLL.line_location_id = p_line_location_id

Line 2608: PO_LINE_LOCATIONS POLL

2604: BEGIN
2605: SELECT round(l_ship_price_in_base_curr(shipment_line),nvl(FND.extended_precision,5))
2606: INTO l_ship_price_ext_precn
2607: FROM FND_CURRENCIES FND, PO_HEADERS POH,
2608: PO_LINE_LOCATIONS POLL
2609: WHERE POH.po_header_id = POLL.po_header_id
2610: AND POH.currency_code = FND.currency_code
2611: AND POLL.line_location_id = l_line_location_id(shipment_line);
2612: EXCEPTION

Line 2915: FROM PO_LINES POL,PO_RELEASES POR,PO_LINE_LOCATIONS PLL

2911: SELECT substr(g_reqmsg||g_delim||p_req_num||g_delim||
2912: g_linemsg||g_delim||p_req_line_num||
2913: g_delim||l_textline||g_delim||POL.min_release_amount,1,240)
2914: BULK COLLECT INTO l_error_messages
2915: FROM PO_LINES POL,PO_RELEASES POR,PO_LINE_LOCATIONS PLL
2916: WHERE PLL.po_release_id = POR.po_release_id
2917: AND PLL.po_release_id = x_po_release_id
2918: AND POL.po_line_id = PLL.po_line_id
2919: AND POL.min_release_amount is not null

Line 2926: FROM PO_LINE_LOCATIONS PLL2

2922: decode(sum(nvl(PLL2.quantity,0)-nvl(PLL2.quantity_cancelled,0)),
2923: 0,POL.min_release_amount,
2924: sum((nvl(PLL2.quantity,0)-nvl(PLL2.quantity_cancelled,0))
2925: *PLL2.price_override))
2926: FROM PO_LINE_LOCATIONS PLL2
2927: WHERE PLL2.po_line_id = POL.po_line_id
2928: AND PLL2.po_release_id = POR.po_release_id
2929: AND PLL2.shipment_type in ('BLANKET', 'SCHEDULED'))
2930: GROUP BY POL.line_num,POL.min_release_amount;

Line 2970: FROM PO_DISTRIBUTIONS POD, PO_LINE_LOCATIONS PLL, PO_LINES POL

2966: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_PDOI_INVALID_GL_ENC_PER');
2967: SELECT substr(l_textline,1,240),
2968: POD.po_distribution_id
2969: BULK COLLECT INTO l_error_messages, l_dist_id
2970: FROM PO_DISTRIBUTIONS POD, PO_LINE_LOCATIONS PLL, PO_LINES POL
2971: WHERE POD.line_location_id = PLL.line_location_id
2972: AND PLL.po_release_id = x_po_release_id
2973: AND POL.po_line_id = PLL.po_line_id
2974: AND nvl(POD.encumbered_flag,'N') = 'N'

Line 3028: FROM MTL_UOM_CLASS_CONVERSIONS MOU, PO_LINE_LOCATIONS POLL,

3024: SELECT substr(l_textline||g_delim||
3025: MTL1.uom_class||' , '||MTL2.uom_class,1,240),
3026: POLL.line_location_id
3027: BULK COLLECT INTO l_error_messages, l_line_location_id
3028: FROM MTL_UOM_CLASS_CONVERSIONS MOU, PO_LINE_LOCATIONS POLL,
3029: PO_LINES POL, MTL_UOM_CLASSES_TL MTL1,
3030: MTL_UOM_CLASSES_TL MTL2
3031: WHERE MOU.inventory_item_id = POL.item_id
3032: AND (NVL(MOU.disable_date, TRUNC(SYSDATE)) + 1) < TRUNC(SYSDATE)

Line 3075: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,

3071: SELECT substr(g_reqmsg||g_delim||p_req_num||g_delim||
3072: g_linemsg||g_delim||p_req_line_num||
3073: g_delim||l_textline,1,240)
3074: BULK COLLECT INTO l_error_messages
3075: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,
3076: PO_RELEASES POR,PO_LINES POL, PO_HEADERS POH,
3077: FINANCIALS_SYSTEM_PARAMETERS FSP
3078: WHERE POR.po_release_id = x_po_release_id
3079: AND POR.po_header_id = POH.po_header_id

Line 3149: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,

3145: SELECT substr(g_reqmsg||g_delim||p_req_num||g_delim||
3146: g_linemsg||g_delim||p_req_line_num||
3147: g_delim||l_textline,1,240)
3148: BULK COLLECT INTO l_error_messages
3149: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,
3150: PO_RELEASES POR,PO_LINES POL, PO_HEADERS POH,
3151: FINANCIALS_SYSTEM_PARAMETERS FSP
3152: WHERE POR.po_release_id = x_po_release_id
3153: AND POR.po_header_id = POH.po_header_id

Line 3264: PO_LINE_LOCATIONS_ALL PLL

3260:
3261: SELECT substr (g_shipmsg||g_delim||PLL.shipment_num||g_delim||l_textline,1,240)
3262: BULK COLLECT INTO l_error_messages
3263: FROM PO_RELEASES_ALL POR,
3264: PO_LINE_LOCATIONS_ALL PLL
3265: WHERE POR.po_release_id = PLL.po_release_id
3266: AND POR.po_release_id = x_po_release_id
3267: AND Nvl(PLL.LCM_FLAG,'N') = 'Y'
3268: AND Nvl(PLL.match_option,'P') <> 'R';

Line 3291: PO_LINE_LOCATIONS_GT PLL,

3287: SELECT substr (g_shipmsg||g_delim||PLL.shipment_num||g_delim||g_distmsg||g_delim||
3288: POD.distribution_num||g_delim||l_textline, 1,240)
3289: BULK COLLECT INTO l_error_messages
3290: FROM PO_RELEASES_GT POR,
3291: PO_LINE_LOCATIONS_GT PLL,
3292: PO_DISTRIBUTIONS_GT POD
3293: WHERE POR.po_release_id = POD.po_release_id
3294: AND POD.line_location_id = PLL.line_location_id
3295: AND POR.po_release_id = x_po_release_id