APPS.CSM_MULTI_MOBQRY_PKG dependencies on CSP_REQ_LINE_DETAILS

Line 403: from csp_req_line_details rld,

399: decode(mr.serial_number, NULL, mr.reservation_quantity, 1) as ship_quantity,
400: rld.req_line_detail_id,
401: NULL as shipment_number,
402: NULL as shipment_line_id
403: from csp_req_line_details rld,
404: csp_requirement_lines rl,
405: csp_requirement_headers rh,
406: mtl_reservations mr
407: where rld.source_type='RES'

Line 432: from csp_req_line_details rld,

428: decode(rss.serial_num, NULL,oel.shipped_quantity,1) ship_quantity,
429: rld.req_line_detail_id,
430: rch.shipment_num as shipment_number,
431: rcl.shipment_line_id
432: from csp_req_line_details rld,
433: csp_requirement_lines rl,
434: csp_requirement_headers rh ,
435: oe_order_lines_all oel,
436: oe_order_headers_all oeh,

Line 580: FOR rec IN (SELECT USER_ID FROM CSP_REQ_LINE_DETAILS rld ,CSM_REQ_LINE_DETAILS_ACC acc

576: CSM_SERIAL_NUMBERS_EVENT_PKG.RECEIVED_MTL_SERIAL_NUM(r_part_line.destination_organization_id,r_part_line.destination_subinventory
577: ,r_part_line.INVENTORY_ITEM_ID,r_part_line.serial_number,l_user_id);
578: END IF;
579: IF r_part_line.source_type='IO' THEN
580: FOR rec IN (SELECT USER_ID FROM CSP_REQ_LINE_DETAILS rld ,CSM_REQ_LINE_DETAILS_ACC acc
581: WHERE rld.SOURCE_TYPE='IO' AND rld.SOURCE_ID=r_part_line.line_id AND acc.REQ_LINE_DETAIL_ID=rld.REQ_LINE_DETAIL_ID)
582: LOOP --to update received qty
583: l_dummy := asg_download.mark_dirty(
584: p_pub_item => 'CSM_ORDER_LINES'

Line 667: from csp_req_line_details rld,

663: decode(mr.serial_number, NULL, mr.reservation_quantity, 1) as ship_quantity,
664: rld.req_line_detail_id,
665: NULL as shipment_number,
666: NULL as shipment_line_id
667: from csp_req_line_details rld,
668: csp_requirement_lines rl,
669: csp_requirement_headers rh,
670: mtl_reservations mr
671: where rld.source_type='RES'

Line 696: from csp_req_line_details rld,

692: decode(rss.serial_num, NULL,oel.shipped_quantity,1) ship_quantity,
693: rld.req_line_detail_id,
694: rch.shipment_num as shipment_number,
695: rcl.shipment_line_id
696: from csp_req_line_details rld,
697: csp_requirement_lines rl,
698: csp_requirement_headers rh ,
699: oe_order_lines_all oel,
700: oe_order_headers_all oeh,

Line 853: FOR rec IN (SELECT USER_ID FROM CSP_REQ_LINE_DETAILS rld ,CSM_REQ_LINE_DETAILS_ACC acc

849: CSM_SERIAL_NUMBERS_EVENT_PKG.RECEIVED_MTL_SERIAL_NUM(r_part_line.destination_organization_id,r_part_line.destination_subinventory
850: ,r_part_line.INVENTORY_ITEM_ID,r_part_line.serial_number,l_user_id);
851: END IF;
852: IF r_part_line.source_type='IO' AND NOT l_dummy THEN
853: FOR rec IN (SELECT USER_ID FROM CSP_REQ_LINE_DETAILS rld ,CSM_REQ_LINE_DETAILS_ACC acc
854: WHERE rld.SOURCE_TYPE='IO' AND rld.SOURCE_ID=r_part_line.line_id AND acc.REQ_LINE_DETAIL_ID=rld.REQ_LINE_DETAIL_ID)
855: LOOP --to update received qty
856: l_dummy := asg_download.mark_dirty(
857: p_pub_item => 'CSM_ORDER_LINES'