APPS.OE_CANCEL dependencies on SO_LINE_DETAILS

Line 79: FROM SO_LINE_DETAILS SLD,

75: END IF;
76: ELSE
77: SELECT COUNT(*)
78: INTO DUMMY
79: FROM SO_LINE_DETAILS SLD,
80: SO_LINES SOL
81: WHERE SOL.HEADER_ID = V_HEADER_ID
82: AND SLD.LINE_ID = SOL.LINE_ID
83: AND SLD.SCHEDULE_STATUS_CODE = 'SUPPLY_RESERVED'

Line 114: -- corresponding so_line_details for the order just cancelled,

110: -- For those record found in the interface set the quantity to 0
111: -- and set the closed_flag to 'Y'.
112: -- Need to insert a record into so_order_cancellations indicating
113: -- the order level cancellation. We also need to detele the
114: -- corresponding so_line_details for the order just cancelled,
115: -- excluding any line details that have been released. Also
116: -- need to cleanup the so_line_service_details if there were any
117: -- lines that were of a service nature.
118: --

Line 314: DELETE FROM SO_LINE_DETAILS

310: V_LAST_UPDATED_BY, SYSDATE,
311: V_LAST_UPDATE_LOGIN, SYSDATE,
312: v_current_user, V_CANCEL_COMMENT );
313:
314: DELETE FROM SO_LINE_DETAILS
315: WHERE LINE_ID IN (
316: SELECT LINE_ID
317: FROM SO_LINES
318: WHERE HEADER_ID = V_HEADER_ID)

Line 471: FROM SO_LINE_DETAILS

467:
468: BEGIN
469: SELECT COUNT(*)
470: INTO DUMMY
471: FROM SO_LINE_DETAILS
472: WHERE LINE_ID = V_LOOP_LINE_ID
473: AND CONFIGURATION_ITEM_FLAG = 'Y';
474:
475: IF (DUMMY >= 1) THEN

Line 636: FROM SO_LINE_DETAILS

632:
633:
634: SELECT COUNT(*)
635: INTO DUMMY
636: FROM SO_LINE_DETAILS
637: WHERE LINE_ID = V_LOOP_LINE_ID
638: AND SHIPPABLE_FLAG = 'Y'
639: AND INCLUDED_ITEM_FLAG = 'N';
640:

Line 647: from so_line_details

643: IF ( V_S2 <> 4) then
644:
645: select nvl(sum(quantity),0)
646: into LD_QTY
647: from so_line_details
648: where nvl(released_flag,'N') = 'N'
649: and line_id = V_LOOP_LINE_ID
650: and included_item_flag = 'N'
651: and nvl(schedule_status_code,'NULL') <> 'SUPPLY RESERVED';

Line 726: from so_line_details

722:
723:
724: CURSOR c1 IS
725: select distinct inventory_item_id, component_ratio
726: from so_line_details
727: where line_id = V_LOOP_LINE_ID
728: and included_item_flag = 'Y'
729: order by inventory_item_id;
730:

Line 741: from so_line_details sld

737: IF ( V_S2 <> 4) then
738:
739: select nvl(sum(sld.quantity),0)
740: into LD_QTY
741: from so_line_details sld
742: where nvl(sld.released_flag,'N') = 'N'
743: and sld.line_id = V_LOOP_LINE_ID
744: and sld.inventory_item_id = TEMP_ITEM_ID
745: and nvl(sld.schedule_status_code,'NULL') <> 'SUPPLY RESERVED';

Line 772: from so_line_details sld

768: ** cases.
769: */
770: select nvl(sum(sld.quantity),0) + PD_QTY
771: into PD_QTY
772: from so_line_details sld
773: where nvl(sld.released_flag,'N') = 'Y'
774: and nvl(sld.shippable_flag,'N') = 'N'
775: and sld.line_id = V_LOOP_LINE_ID
776: and sld.inventory_item_id = TEMP_ITEM_ID

Line 826: FROM SO_LINE_DETAILS

822: IF (V_S2 <> 4) then
823:
824: SELECT NVL(SUM(QUANTITY),0)
825: INTO LD_QTY
826: FROM SO_LINE_DETAILS
827: WHERE LINE_ID = V_ATO_LOOP_LINE_ID
828: AND CONFIGURATION_ITEM_FLAG = 'Y'
829: AND RELEASED_FLAG = 'N'
830: AND NVL(SCHEDULE_STATUS_CODE,'NULL') <> 'SUPPLY RESERVED';