[Home] [Help]
995: END;
996: --3.Is non-stock material receipt Done
997: --4.Is Direct material receipt done
998: --5.IS Out side processing (OSP) receipt done
999: --EAM_WO_DIRECT_ITEMS_LITE_V. quantity_received > 0 or EAM_WO_DIRECT_ITEMS_LITE_V. amount_delivered > 0
1000: BEGIN
1001: SELECT nvl(sum(quantity_received), 0),
1002: nvl(sum(amount_delivered), 0)
1003: INTO l_q_received,
1001: SELECT nvl(sum(quantity_received), 0),
1002: nvl(sum(amount_delivered), 0)
1003: INTO l_q_received,
1004: l_amount_delivered
1005: FROM eam_wo_direct_items_lite_v
1006: WHERE wip_entity_id = p_wip_entity_id
1007: AND operation_seq_num = p_op_seq_num;
1008:
1009: IF l_q_received > 0 OR l_amount_delivered > 0 THEN