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.CSP_PARTS_REQUIREMENT dependencies on CSP_REQUIREMENT_LINES

Line 166: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;

162: l_line_tbl Line_Tbl_type;
163:
164: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;
165:
166: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
167: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
168: x_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
169: l_req_line_details_tbl csp_parts_requirement.Line_detail_Tbl_Type;
170: j NUMBER;

Line 167: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;

163:
164: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;
165:
166: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
167: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
168: x_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
169: l_req_line_details_tbl csp_parts_requirement.Line_detail_Tbl_Type;
170: j NUMBER;
171:

Line 168: x_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;

164: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;
165:
166: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
167: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
168: x_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
169: l_req_line_details_tbl csp_parts_requirement.Line_detail_Tbl_Type;
170: j NUMBER;
171:
172: --Record types and tbl types for finding availability of parts

Line 508: from csp_requirement_lines

504: ELSE
505: BEGIN
506: select requirement_line_id
507: into l_check_existence
508: from csp_requirement_lines
509: where requirement_line_id = l_line_rec.requirement_line_id;
510: EXCEPTION
511: WHEN NO_DATA_FOUND THEN
512: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');

Line 521: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);

517: WHEN OTHERS THEN
518: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
519: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
520: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
521: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
522: FND_MSG_PUB.ADD;
523: RAISE EXCP_USER_DEFINED;
524: END;
525: END IF;

Line 669: -- call private api for inserting into csp_requirement_lines

665: FOR I in 1..l_rqmt_line_Tbl.COUNT LOOP
666: l_rqmt_line_Tbl(I).requirement_header_id := l_requirement_header_id;
667: END LOOP;
668: x_rqmt_line_tbl := l_rqmt_line_tbl;
669: -- call private api for inserting into csp_requirement_lines
670: CSP_Requirement_Lines_PVT.Create_requirement_lines(
671: P_Api_Version_Number => l_api_version_number,
672: P_Init_Msg_List => p_Init_Msg_List,
673: P_Commit => FND_API.G_FALSE,

Line 670: CSP_Requirement_Lines_PVT.Create_requirement_lines(

666: l_rqmt_line_Tbl(I).requirement_header_id := l_requirement_header_id;
667: END LOOP;
668: x_rqmt_line_tbl := l_rqmt_line_tbl;
669: -- call private api for inserting into csp_requirement_lines
670: CSP_Requirement_Lines_PVT.Create_requirement_lines(
671: P_Api_Version_Number => l_api_version_number,
672: P_Init_Msg_List => p_Init_Msg_List,
673: P_Commit => FND_API.G_FALSE,
674: p_validation_level => null,

Line 729: CSP_Requirement_Lines_PVT.Update_requirement_lines(

725: END IF;
726:
727: -- call private api for updating requirement lines
728: --FOR I in 1..l_rqmt_line_tbl.COUNT LOOP
729: CSP_Requirement_Lines_PVT.Update_requirement_lines(
730: P_Api_Version_Number => l_api_version_number,
731: P_Init_Msg_List => p_Init_Msg_List,
732: P_Commit => FND_API.G_FALSE,
733: p_validation_level => null,

Line 828: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;

824: l_resource_subinv VARCHAR2(30);
825: l_reservation_rec CSP_SCH_INT_PVT.RESERVATION_REC_TYP;
826: l_local_reservation_id NUMBER;
827:
828: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
829: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
830:
831: CURSOR rs_info_cur(p_rqmt_header_id NUMBER) IS
832: SELECT cla.organization_id,

Line 829: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;

825: l_reservation_rec CSP_SCH_INT_PVT.RESERVATION_REC_TYP;
826: l_local_reservation_id NUMBER;
827:
828: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
829: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
830:
831: CURSOR rs_info_cur(p_rqmt_header_id NUMBER) IS
832: SELECT cla.organization_id,
833: cla.subinventory_code

Line 922: update csp_Requirement_lines

918: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
919: RAISE FND_API.G_EXC_ERROR;
920: END If;
921:
922: update csp_Requirement_lines
923: set local_Reservation_id = l_local_Reservation_id
924: where requirement_line_id = l_line_Rec.requirement_line_id;
925:
926: END IF;

Line 970: from csp_requirement_lines

966: ELSE
967: BEGIN
968: select requirement_line_id
969: into l_check_existence
970: from csp_requirement_lines
971: where requirement_line_id = l_line_rec.requirement_line_id;
972: EXCEPTION
973: WHEN NO_DATA_FOUND THEN
974: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');

Line 982: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);

978: WHEN OTHERS THEN
979: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
980: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
981: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
982: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
983: FND_MSG_PUB.ADD;
984: RAISE EXCP_USER_DEFINED;
985: END;
986: END IF;

Line 1036: from csp_requirement_lines

1032: ELSE
1033: BEGIN
1034: select requirement_line_id
1035: into l_check_existence
1036: from csp_requirement_lines
1037: where requirement_line_id = l_line_rec.requirement_line_id;
1038: EXCEPTION
1039: WHEN NO_DATA_FOUND THEN
1040: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');

Line 1048: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);

1044: WHEN OTHERS THEN
1045: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1046: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
1047: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
1048: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
1049: FND_MSG_PUB.ADD;
1050: RAISE EXCP_USER_DEFINED;
1051: END;
1052: END IF;

Line 1072: CSP_Requirement_Lines_PVT.Update_requirement_lines(

1068: END IF;
1069:
1070: IF (l_rqmt_line_Tbl.count > 0) THEN
1071:
1072: CSP_Requirement_Lines_PVT.Update_requirement_lines(
1073: P_Api_Version_Number => l_api_version_number,
1074: P_Init_Msg_List => p_Init_Msg_List,
1075: P_Commit => p_commit,
1076: p_validation_level => null,

Line 1482: FROM csp_requirement_lines crl, csp_req_line_Details crld

1478:
1479: IF (p_header_id IS NOT NULL) THEN
1480: SELECT count(*)
1481: INTO l_count
1482: FROM csp_requirement_lines crl, csp_req_line_Details crld
1483: WHERE crl.requirement_header_id = p_header_id
1484: AND crl.requirement_line_id = crld.requirement_line_id;
1485:
1486: IF l_count > 0 THEN

Line 1492: DELETE FROM csp_requirement_lines

1488: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_header_id', FALSE);
1489: FND_MSG_PUB.ADD;
1490: RAISE EXCP_USER_DEFINED;
1491: ELSE
1492: DELETE FROM csp_requirement_lines
1493: WHERE requirement_header_id = p_header_id;
1494:
1495: DELETE FROM csp_requirement_headers
1496: WHERE requirement_header_id = p_header_id;

Line 1562: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;

1558: l_login_id NUMBER;
1559: l_today DATE;
1560: l_parts_defined VARCHAR2(30);
1561: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;
1562: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
1563: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
1564: l_rqmt_line_Tbl_out csp_requirement_lines_pvt.requirement_line_tbl_type;
1565: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1566: l_msg_count NUMBER;

Line 1563: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;

1559: l_today DATE;
1560: l_parts_defined VARCHAR2(30);
1561: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;
1562: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
1563: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
1564: l_rqmt_line_Tbl_out csp_requirement_lines_pvt.requirement_line_tbl_type;
1565: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1566: l_msg_count NUMBER;
1567: l_msg_data VARCHAR2(2000);

Line 1564: l_rqmt_line_Tbl_out csp_requirement_lines_pvt.requirement_line_tbl_type;

1560: l_parts_defined VARCHAR2(30);
1561: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;
1562: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
1563: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
1564: l_rqmt_line_Tbl_out csp_requirement_lines_pvt.requirement_line_tbl_type;
1565: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1566: l_msg_count NUMBER;
1567: l_msg_data VARCHAR2(2000);
1568: l_requirement_header_id NUMBER;

Line 1594: from csp_requirement_lines crl,

1590: crl.inventory_item_id ,
1591: crl.revision,
1592: crl.required_quantity,
1593: crl.uom_code
1594: from csp_requirement_lines crl,
1595: csp_req_line_details crld
1596: where crld.requirement_line_id(+) = crl.requirement_line_id
1597: and crl.requirement_header_id = p_rqmt_header_id
1598: and crld.source_id is null;

Line 1915: from csp_requirement_lines

1911:
1912: BEGIN
1913: select count(*)
1914: into l_count
1915: from csp_requirement_lines
1916: where requirement_line_id = l_rqmt_line_rec.requirement_line_id;
1917: IF l_count > 0 THEN
1918: fnd_message.set_name('CSP', 'CSP_DUPLICATE_RQMT_LINE');
1919: FND_MSG_PUB.ADD;

Line 1959: CSP_Requirement_Lines_PVT.Create_requirement_lines(

1955:
1956: l_rqmt_line_tbl(I) := l_rqmt_line_rec;
1957: END LOOP;
1958:
1959: CSP_Requirement_Lines_PVT.Create_requirement_lines(
1960: P_Api_Version_Number => l_api_version_number,
1961: P_Init_Msg_List => p_Init_Msg_List,
1962: P_Commit => FND_API.G_FALSE,
1963: p_validation_level => null,

Line 2068: DELETE FROM csp_Requirement_lines

2064: x_return_status := FND_API.G_RET_STS_SUCCESS;
2065:
2066: IF (p_line_tbl.count > 0) THEN
2067: FOR I IN 1..p_line_Tbl.count LOOP
2068: DELETE FROM csp_Requirement_lines
2069: WHERE requirement_line_id = p_line_tbl(I).requirement_line_id;
2070: END LOOP;
2071: END IF;
2072:

Line 2127: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;

2123: l_count NUMBER;
2124: l_header_rec csp_parts_requirement.Header_rec_type;
2125: l_line_rec csp_parts_requirement.line_rec_type;
2126: l_line_tbl csp_parts_Requirement.line_Tbl_type;
2127: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
2128: EXCP_USER_DEFINED EXCEPTION;
2129: l_parts_list_rec csp_sch_int_pvt.csp_parts_rec_type;
2130: l_parts_list_tbl csp_sch_int_pvt.csp_parts_tbl_typ1;
2131: l_avail_list_tbl csp_sch_int_pvt.available_parts_tbl_typ1;

Line 2143: from csp_requirement_lines crl,

2139: select crl.requirement_line_id,
2140: crl.inventory_item_id,
2141: crl.uom_code,
2142: crl.required_quantity
2143: from csp_requirement_lines crl,
2144: csp_req_line_details crld
2145: where crld.requirement_line_id(+) = crl.requirement_line_id
2146: and crl.requirement_header_id = p_header_id
2147: and crld.source_id is null;

Line 2172: from csp_requirement_lines crl,

2168:
2169: IF (p_header_id IS NOT NULL) THEN
2170: select count(*)
2171: into l_count
2172: from csp_requirement_lines crl,
2173: csp_req_line_details crld
2174: where crld.requirement_line_id(+) = crl.requirement_line_id
2175: and crl.requirement_header_id = p_header_id
2176: and crld.source_id is null;

Line 2304: CSP_Requirement_Lines_PVT.Update_requirement_lines(

2300: l_rqmt_line_tbl(I).ordered_quantity := nvl(l_line_Tbl(I).ordered_quantity, 0);
2301: END LOOP;
2302:
2303: IF l_rqmt_line_tbl.COUNT > 0 THEN
2304: CSP_Requirement_Lines_PVT.Update_requirement_lines(
2305: P_Api_Version_Number => l_api_version_number,
2306: P_Init_Msg_List => p_Init_Msg_List,
2307: P_Commit => FND_API.G_FALSE,
2308: p_validation_level => null,

Line 2384: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;

2380: l_line_rec csp_parts_requirement.line_rec_type;
2381: l_line_tbl csp_parts_Requirement.line_Tbl_type;
2382: l_oe_line_tbl csp_parts_requirement.line_Tbl_Type;
2383: l_po_line_Tbl csp_parts_requirement.line_tbl_type;
2384: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
2385: EXCP_USER_DEFINED EXCEPTION;
2386: I NUMBER;
2387: J NUMBER;
2388: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 2409: FROM csp_requirement_lines c

2405: c.source_organization_id,
2406: c.source_subinventory,
2407: c.shipping_method_code,
2408: c.arrival_date
2409: FROM csp_requirement_lines c
2410: WHERE c.requirement_header_id = p_header_id
2411: AND not exists (select 1 from csp_req_line_Details d where d.requirement_line_id = c.requirement_line_id)
2412: FOR UPDATE of c.order_line_id NOWAIT;
2413:

Line 2456: from csp_requirement_lines crl,

2452:
2453: IF (p_header_id IS NOT NULL) THEN
2454: select count(*)
2455: into l_count
2456: from csp_requirement_lines crl,
2457: csp_req_line_details crld
2458: where crld.requirement_line_id(+) = crl.requirement_line_id
2459: and crl.requirement_header_id = p_header_id
2460: and crld.source_id is null;

Line 2816: csp_requirement_lines line,

2812: CURSOR check_IO_booked IS
2813: select head.requirement_header_id, count(dtl.source_type)
2814: from
2815: csp_requirement_headers head,
2816: csp_requirement_lines line,
2817: csp_req_line_details dtl,
2818: oe_order_lines_all oel
2819: where
2820: head.task_assignment_id = l_Task_Assignment_id

Line 2832: csp_requirement_lines line,

2828: CURSOR get_req_line_dtl(v_req_header_id number) is
2829: select dtl.req_line_detail_id, dtl.source_id, dtl.source_type
2830: from
2831: csp_requirement_headers head,
2832: csp_requirement_lines line,
2833: csp_req_line_details dtl
2834: where
2835: head.requirement_header_id = v_req_header_id
2836: and head.requirement_header_id = line.requirement_header_id

Line 2848: csp_requirement_lines cl,

2844: cursor get_order_header_id is
2845: SELECT oel.header_id
2846: FROM jtf_task_assignments jta,
2847: csp_requirement_headers ch,
2848: csp_requirement_lines cl,
2849: csp_req_line_details cld,
2850: oe_order_lines_all oel
2851: WHERE jta.task_assignment_id = l_task_assignment_id
2852: AND ch.task_assignment_id = jta.task_assignment_id

Line 2897: csp_requirement_lines l

2893: cursor get_non_src_req is
2894: SELECT h.requirement_header_id,
2895: h.address_type
2896: FROM csp_requirement_headers h,
2897: csp_requirement_lines l
2898: WHERE h.task_id = l_task_id
2899: AND h.task_assignment_id = l_task_assignment_id
2900: AND l.requirement_header_id = h.requirement_header_id
2901: AND (SELECT COUNT(d.source_id)

Line 2942: csp_requirement_lines l

2938: l_oth_req_line := 0;
2939: SELECT COUNT(l.requirement_line_id)
2940: INTO l_oth_req_line
2941: FROM csp_requirement_headers h,
2942: csp_requirement_lines l
2943: WHERE h.task_id = l_task_id
2944: AND h.task_assignment_id = l_task_assignment_id
2945: AND h.requirement_header_id = l.requirement_header_id;
2946:

Line 3214: csp_requirement_lines l,

3210: l_partial_line := 0;
3211: SELECT count(l.requirement_line_id)
3212: into l_partial_line
3213: FROM csp_requirement_headers h,
3214: csp_requirement_lines l,
3215: csp_req_line_details d,
3216: oe_order_lines_all oola
3217: WHERE h.task_id = l_task_id
3218: AND h.task_assignment_id = l_Task_Assignment_id

Line 3247: csp_requirement_lines l,

3243: l_fl_rcvd_lines := 0;
3244: SELECT COUNT(l.requirement_line_id)
3245: into l_fl_rcvd_lines
3246: FROM csp_requirement_headers h,
3247: csp_requirement_lines l,
3248: csp_req_line_details dio,
3249: csp_req_line_details dres,
3250: oe_order_lines_all oola,
3251: mtl_reservations mr

Line 3275: csp_requirement_lines l,

3271: if l_fl_rcvd_lines > 0 then
3272: SELECT ooha.order_number
3273: into l_order_number
3274: FROM csp_requirement_headers h,
3275: csp_requirement_lines l,
3276: csp_req_line_details dio,
3277: oe_order_lines_all oola,
3278: oe_order_headers_all ooha
3279: WHERE h.task_id = l_task_id

Line 3304: csp_requirement_lines l,

3300: l_fl_rcvd_lines := 0;
3301: SELECT COUNT(l.requirement_line_id)
3302: into l_fl_rcvd_lines
3303: FROM csp_requirement_headers h,
3304: csp_requirement_lines l,
3305: csp_req_line_details dio,
3306: csp_req_line_details dres,
3307: oe_order_lines_all oola,
3308: mtl_reservations mr

Line 3335: csp_requirement_lines l,

3331: l_fl_rcvd_multi_source := 0;
3332: SELECT COUNT(l.requirement_line_id)
3333: into l_fl_rcvd_multi_source
3334: FROM csp_requirement_headers h,
3335: csp_requirement_lines l,
3336: csp_req_line_details dio,
3337: csp_req_line_details dres,
3338: csp_req_line_details dother,
3339: oe_order_lines_all oola,

Line 3380: csp_requirement_lines l,

3376: into l_oth_req_line
3377: FROM
3378: (SELECT l.requirement_line_id
3379: FROM csp_requirement_headers h,
3380: csp_requirement_lines l,
3381: csp_req_line_details d
3382: WHERE h.task_id = l_task_id
3383: AND h.task_assignment_id = l_Task_Assignment_id
3384: AND h.requirement_header_id = l.requirement_header_id

Line 3390: csp_requirement_lines l,

3386: AND l.requirement_line_id = d.requirement_line_id
3387: MINUS
3388: SELECT l.requirement_line_id
3389: FROM csp_requirement_headers h,
3390: csp_requirement_lines l,
3391: csp_req_line_details dio,
3392: csp_req_line_details dres,
3393: oe_order_lines_all oola,
3394: mtl_reservations mr

Line 3432: csp_requirement_lines l

3428: into l_non_src_line
3429: FROM
3430: (SELECT l.requirement_line_id
3431: FROM csp_requirement_headers h,
3432: csp_requirement_lines l
3433: WHERE h.task_id = l_task_id
3434: AND h.task_assignment_id = l_Task_Assignment_id
3435: AND h.requirement_header_id = l.requirement_header_id
3436: AND h.address_type IN ('T', 'C', 'P')

Line 3443: csp_requirement_lines l,

3439: WHERE d.requirement_line_id = l.requirement_line_id) = 0
3440: MINUS
3441: SELECT l.requirement_line_id
3442: FROM csp_requirement_headers h,
3443: csp_requirement_lines l,
3444: csp_req_line_details dio,
3445: csp_req_line_details dres,
3446: oe_order_lines_all oola,
3447: mtl_reservations mr

Line 3507: csp_requirement_lines l,

3503: l_shpd_lines := 0;
3504: SELECT COUNT(l.requirement_line_id)
3505: into l_shpd_lines
3506: FROM csp_requirement_headers h,
3507: csp_requirement_lines l,
3508: csp_req_line_details d,
3509: oe_order_lines_all oola
3510: WHERE h.task_id = l_task_id
3511: AND h.task_assignment_id = l_Task_Assignment_id

Line 3541: csp_requirement_lines l,

3537: if l_tech_spec_pr > 0 then
3538: SELECT ooha.order_number
3539: INTO l_order_number
3540: FROM csp_requirement_headers h,
3541: csp_requirement_lines l,
3542: csp_req_line_details d,
3543: oe_order_lines_all oola,
3544: oe_order_headers_all ooha
3545: WHERE h.task_assignment_id = l_Task_Assignment_id

Line 3569: csp_requirement_lines l,

3565: l_ship_multi_src := 0;
3566: SELECT COUNT(l.requirement_line_id)
3567: into l_ship_multi_src
3568: FROM csp_requirement_headers h,
3569: csp_requirement_lines l,
3570: csp_req_line_details d,
3571: csp_req_line_details dother,
3572: oe_order_lines_all oola
3573: WHERE h.task_id = l_task_id

Line 3606: csp_requirement_lines l,

3602: into l_oth_req_line
3603: FROM
3604: (SELECT l.requirement_line_id
3605: FROM csp_requirement_headers h,
3606: csp_requirement_lines l,
3607: csp_req_line_details d
3608: WHERE h.task_id = l_task_id
3609: AND h.task_assignment_id = l_Task_Assignment_id
3610: AND h.requirement_header_id = l.requirement_header_id

Line 3615: csp_requirement_lines l,

3611: AND l.requirement_line_id = d.requirement_line_id
3612: MINUS
3613: SELECT l.requirement_line_id
3614: FROM csp_requirement_headers h,
3615: csp_requirement_lines l,
3616: csp_req_line_details d,
3617: oe_order_lines_all oola
3618: WHERE h.task_id = l_task_id
3619: AND h.task_assignment_id = l_Task_Assignment_id

Line 3649: csp_requirement_lines l

3645: into l_non_src_line
3646: FROM
3647: (SELECT l.requirement_line_id
3648: FROM csp_requirement_headers h,
3649: csp_requirement_lines l
3650: WHERE h.task_id = l_task_id
3651: AND h.task_assignment_id = l_Task_Assignment_id
3652: AND h.requirement_header_id = l.requirement_header_id
3653: AND (SELECT COUNT (d.requirement_line_id)

Line 3659: csp_requirement_lines l,

3655: WHERE d.requirement_line_id = l.requirement_line_id) = 0
3656: MINUS
3657: SELECT l.requirement_line_id
3658: FROM csp_requirement_headers h,
3659: csp_requirement_lines l,
3660: csp_req_line_details d,
3661: oe_order_lines_all oola
3662: WHERE h.task_id = l_task_id
3663: AND h.task_assignment_id = l_Task_Assignment_id

Line 4162: csp_requirement_lines rl

4158: AND rh.task_assignment_id IS NULL
4159: AND NOT EXISTS
4160: (SELECT 1
4161: FROM csp_req_line_details rld,
4162: csp_requirement_lines rl
4163: WHERE rl.requirement_line_id = rld.requirement_line_id
4164: AND rl.requirement_header_id = rh.requirement_header_id);
4165:
4166: CURSOR get_Resource_org_sub IS

Line 4552: csp_requirement_lines l,

4548: l_dtl_count := 0;
4549: SELECT COUNT(*)
4550: INTO l_dtl_count
4551: FROM csp_requirement_headers h,
4552: csp_requirement_lines l,
4553: csp_req_line_details d
4554: WHERE h.task_assignment_id = l_task_assignment_id
4555: AND h.task_id = l_task_id
4556: AND h.requirement_header_id = l.requirement_header_id