APPS.CSD_DEPOT_REPAIR_CNTR dependencies on CSD_REPAIR_JOB_XREF

Line 814: from CSD_REPAIR_JOB_XREF CRJ

810: crj.quantity_completed,
811: crj.quantity,
812: csr.promise_date,
813: crj.organization_id
814: from CSD_REPAIR_JOB_XREF CRJ
815: ,CSD_REPAIRS csr
816: where
817: csr.repair_line_id = crj.repair_line_id
818: and

Line 865: csd_gen_utility_pvt.add('Updating csd_repair_job_xref for wip_entity_name : '||v_wen);

861:
862: End;
863:
864: IF (g_debug > 0 ) THEN
865: csd_gen_utility_pvt.add('Updating csd_repair_job_xref for wip_entity_name : '||v_wen);
866: END IF;
867:
868: IF (g_debug > 0 ) THEN
869: csd_gen_utility_pvt.add('wip_entity_id ='||TO_CHAR(K.wip_entity_id));

Line 875: update csd_repair_job_xref

871:
872: -- Updating Null Value for v_wei when WIP Mass load program is not completed
873: -- so should not update when v_wei is null bug# 2770713 saupadhy
874: Begin
875: update csd_repair_job_xref
876: set wip_entity_id = v_wei
877: where repair_line_id = K.repair_line_id
878: and repair_job_xref_id = K.repair_job_xref_id
879: and v_wei is not null;

Line 912: Select nvl(sum(quantity_completed),0) into SumOfROCompQty from csd_repair_job_xref where wip_entity_id = i.wip_entity_id;

908: csd_gen_utility_pvt.add('x_wip_completed_qty ='||TO_CHAR(x_wip_completed_qty));
909: END IF;
910:
911: -- get SIGMA ro_completed_qty
912: Select nvl(sum(quantity_completed),0) into SumOfROCompQty from csd_repair_job_xref where wip_entity_id = i.wip_entity_id;
913:
914: v_transaction_quantity := nvl(x_wip_completed_qty,0) - nvl(SumOfROCompQty,0);
915: if (v_transaction_quantity + nvl(i.quantity_completed,0)) > nvl(i.quantity,0) then
916: v_transaction_quantity := nvl(i.quantity,0) - nvl(i.quantity_completed,0);

Line 951: Select nvl(sum(quantity_completed),0) into SumOfROCompQty from csd_repair_job_xref where wip_entity_id = i.wip_entity_id;

947: End;
948: end if;
949: /*
950: -- get SIGMA ro_completed_qty
951: Select nvl(sum(quantity_completed),0) into SumOfROCompQty from csd_repair_job_xref where wip_entity_id = i.wip_entity_id;
952:
953: v_transaction_quantity := nvl(x_wip_completed_qty,0) - nvl(SumOfROCompQty,0);
954: if (v_transaction_quantity + nvl(i.quantity_completed,0)) > nvl(i.quantity,0) then
955: v_transaction_quantity := nvl(i.quantity,0) - nvl(i.quantity_completed,0);

Line 970: update csd_repair_job_xref

966: v_completed_qty := i.quantity;
967: END if;
968: */
969: if (v_transaction_quantity > 0) then --0430
970: update csd_repair_job_xref
971: set quantity_completed =v_completed_qty
972: where repair_line_id = i.repair_line_id
973: and repair_job_xref_id = i.repair_job_xref_id;
974: